Databases and forms

[El tonino]

Hi I have a question having reached the end of my coding knowledge

I have succesfully created a site, ready to publish, but would like to make
a chaneg and not sure if it is possible, how to do it, etc etc

At present - People can submit information on a form onto an SQL database.
People can then search the database using a frontpage "search wizard" web
page which appears to work well.
What i would like to do is - When people submit data, populate a database
and create a seperate web page so when someone searches the database, if they
click on a search result it will bring up the associated web page for that
record. Really just to allow pics and text to appear in a better format that
is easier on the eye (at present the search results create a fairly standard
table). Anyone know if this is possible?


Hope that made sense

 

[Stefan B Rusynko]

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL database.
| People can then search the database using a frontpage "search wizard" web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a database
| and create a seperate web page so when someone searches the database, if they
| click on a search result it will bring up the associated web page for that
| record. Really just to allow pics and text to appear in a better format that
| is easier on the eye (at present the search results create a fairly standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[El tonino]

Doh!!!
Thanks for the reply anyhow.
I will try and word it beter below (apologies for the bad explanation, new
to web pages so struggling a little)

My problem is, I have created a form for people to submit data to a website,
this populates a database and I have created a search page (created using
search wizard) for people to search the database with the search results
populating a webpage in a nice and neat table format

The form allows people to send both text and upload pictures but I am
deliberately not showing pictures in the search results due to the poor
format. I want to show pictures in a separate web-page to make it look
better.
[Concept taken from property sites, where if you search for a property, a
table appears showing all the results(properties) with limited basic
information. If you click on a result(property) it directs you to a linked
web page with all property details] i am trying to do the same basic thing

The problem is I cannot see how to either........
1) Send form results to a database AND a web page and then hyperlink
database results to the associated webpage to view the pictures
2) or use database results to automatically populate a web template if
someone clicks on the search results.
In the same way property sites allow you to search for properties, then
click on them to show more information in a new web page



--
Thanks for the help
Tonino

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL database.
| People can then search the database using a frontpage "search wizard" web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a database
| and create a seperate web page so when someone searches the database, if they
| click on a search result it will bring up the associated web page for that
| record. Really just to allow pics and text to appear in a better format that
| is easier on the eye (at present the search results create a fairly standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[Kathleen Anderson [MVP - FrontPage]]

I think you may want something like this: How to create a "Pick List" page
and generate a detail page
http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Doh!!!
Thanks for the reply anyhow.
I will try and word it beter below (apologies for the bad explanation, new
to web pages so struggling a little)

My problem is, I have created a form for people to submit data to a
website,
this populates a database and I have created a search page (created using
search wizard) for people to search the database with the search results
populating a webpage in a nice and neat table format

The form allows people to send both text and upload pictures but I am
deliberately not showing pictures in the search results due to the poor
format. I want to show pictures in a separate web-page to make it look
better.
[Concept taken from property sites, where if you search for a property, a
table appears showing all the results(properties) with limited basic
information. If you click on a result(property) it directs you to a linked
web page with all property details] i am trying to do the same basic thing

The problem is I cannot see how to either........
1) Send form results to a database AND a web page and then hyperlink
database results to the associated webpage to view the pictures
2) or use database results to automatically populate a web template if
someone clicks on the search results.
In the same way property sites allow you to search for properties, then
click on them to show more information in a new web page



--
Thanks for the help
Tonino

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to
make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL
database.
| People can then search the database using a frontpage "search wizard"
web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a
database
| and create a seperate web page so when someone searches the database,
if they
| click on a search result it will bring up the associated web page for
that
| record. Really just to allow pics and text to appear in a better format
that
| is easier on the eye (at present the search results create a fairly
standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[El tonino]

Doh!! Sorry for the lack of sense (new to web sites so struggling a little)
But thank you for replying and taking time to have a look

I will try to word better below

I have created a website (not published yet just on own server).
I have created a form to allow people to submit information. Information
includes text and pictures, and this form is set up to populate a databse. I
have also created a search tool (using a search wizard) to allow people to
search the database and the results appear in a web page as a nice neat table
(all done with FP2003 and really pleased how easy it was as VBA limit of my
technical ability)

The table only shows limited information which is intentional (does not show
the pictures as want to show them in a separate web page for better format).
The problem is I cannot see how to link the search results to an associated
webpage to view all information

The concept is based on what I see in property sites - They allow you to
search for properties in an area, bring up a list of properties with limited
info. If you then click on one of the search results it takes you to a new
page with all the property information showing

My site shows the best value private ski accomodation people have stayed in.
I want people to submit photos and words on why they liked it. Then if
someone searches for "Aspen" for instance, it would show a list of
accomodation in Aspen (up to this point managed to do) -then if they liked
sound of one of the hotels, let them click on it and a webpage will show all
the accomodation info submited (all pics, map, good local bars, etc). I just
canot see how to either....

Send form results to a Database, and a Webpage (then would need to link the
database to the webpage for each record - which is where i fall down)

Or

Just send results to a database, and use this information to populate a
standard web-template if that record is chosen

I want it to work like a property site. Where you call up database records
with limited information (this bit done) and if you click on a record it
links to a webpage showing all the information with pictures submitted etc



--
Thanks for the help
Tonino

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL database.
| People can then search the database using a frontpage "search wizard" web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a database
| and create a seperate web page so when someone searches the database, if they
| click on a search result it will bring up the associated web page for that
| record. Really just to allow pics and text to appear in a better format that
| is easier on the eye (at present the search results create a fairly standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[El tonino]

Will try that

Thanks a lot for the help - greatly appreciated
--
Thanks for the help
Tonino

I think you may want something like this: How to create a "Pick List" page
and generate a detail page
http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Doh!!!
Thanks for the reply anyhow.
I will try and word it beter below (apologies for the bad explanation, new
to web pages so struggling a little)

My problem is, I have created a form for people to submit data to a
website,
this populates a database and I have created a search page (created using
search wizard) for people to search the database with the search results
populating a webpage in a nice and neat table format

The form allows people to send both text and upload pictures but I am
deliberately not showing pictures in the search results due to the poor
format. I want to show pictures in a separate web-page to make it look
better.
[Concept taken from property sites, where if you search for a property, a
table appears showing all the results(properties) with limited basic
information. If you click on a result(property) it directs you to a linked
web page with all property details] i am trying to do the same basic thing

The problem is I cannot see how to either........
1) Send form results to a database AND a web page and then hyperlink
database results to the associated webpage to view the pictures
2) or use database results to automatically populate a web template if
someone clicks on the search results.
In the same way property sites allow you to search for properties, then
click on them to show more information in a new web page



--
Thanks for the help
Tonino

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to
make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL
database.
| People can then search the database using a frontpage "search wizard"
web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a
database
| and create a seperate web page so when someone searches the database,
if they
| click on a search result it will bring up the associated web page for
that
| record. Really just to allow pics and text to appear in a better format
that
| is easier on the eye (at present the search results create a fairly
standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[El tonino]

Just wanted to say thanks

Worked a treat
--
Thanks for the help
Tonino

I think you may want something like this: How to create a "Pick List" page
and generate a detail page
http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Doh!!!
Thanks for the reply anyhow.
I will try and word it beter below (apologies for the bad explanation, new
to web pages so struggling a little)

My problem is, I have created a form for people to submit data to a
website,
this populates a database and I have created a search page (created using
search wizard) for people to search the database with the search results
populating a webpage in a nice and neat table format

The form allows people to send both text and upload pictures but I am
deliberately not showing pictures in the search results due to the poor
format. I want to show pictures in a separate web-page to make it look
better.
[Concept taken from property sites, where if you search for a property, a
table appears showing all the results(properties) with limited basic
information. If you click on a result(property) it directs you to a linked
web page with all property details] i am trying to do the same basic thing

The problem is I cannot see how to either........
1) Send form results to a database AND a web page and then hyperlink
database results to the associated webpage to view the pictures
2) or use database results to automatically populate a web template if
someone clicks on the search results.
In the same way property sites allow you to search for properties, then
click on them to show more information in a new web page



--
Thanks for the help
Tonino

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like to
make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL
database.
| People can then search the database using a frontpage "search wizard"
web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a
database
| and create a seperate web page so when someone searches the database,
if they
| click on a search result it will bring up the associated web page for
that
| record. Really just to allow pics and text to appear in a better format
that
| is easier on the eye (at present the search results create a fairly
standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino

 

[Kathleen Anderson [MVP - FrontPage]]

That's great - thanks for the feedback.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Just wanted to say thanks

Worked a treat
--
Thanks for the help
Tonino

I think you may want something like this: How to create a "Pick List"
page
and generate a detail page
http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Doh!!!
Thanks for the reply anyhow.
I will try and word it beter below (apologies for the bad explanation,
new
to web pages so struggling a little)

My problem is, I have created a form for people to submit data to a
website,
this populates a database and I have created a search page (created
using
search wizard) for people to search the database with the search
results
populating a webpage in a nice and neat table format

The form allows people to send both text and upload pictures but I am
deliberately not showing pictures in the search results due to the poor
format. I want to show pictures in a separate web-page to make it look
better.
[Concept taken from property sites, where if you search for a property,
a
table appears showing all the results(properties) with limited basic
information. If you click on a result(property) it directs you to a
linked
web page with all property details] i am trying to do the same basic
thing

The problem is I cannot see how to either........
1) Send form results to a database AND a web page and then hyperlink
database results to the associated webpage to view the pictures
2) or use database results to automatically populate a web template if
someone clicks on the search results.
In the same way property sites allow you to search for properties, then
click on them to show more information in a new web page



--
Thanks for the help
Tonino


:

No, doesn't make sense

To search the content of your DB you will need
to write some server side script as in say
http://www.asp101.com/samples/db_search.asp
or try the DBRW as in say
http://support.microsoft.com/kb/235554
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:

http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi I have a question having reached the end of my coding knowledge
|
| I have succesfully created a site, ready to publish, but would like
to
make
| a chaneg and not sure if it is possible, how to do it, etc etc
|
| At present - People can submit information on a form onto an SQL
database.
| People can then search the database using a frontpage "search
wizard"
web
| page which appears to work well.
| What i would like to do is - When people submit data, populate a
database
| and create a seperate web page so when someone searches the
database,
if they
| click on a search result it will bring up the associated web page
for
that
| record. Really just to allow pics and text to appear in a better
format
that
| is easier on the eye (at present the search results create a fairly
standard
| table). Anyone know if this is possible?
|
|
| Hope that made sense
|
|
| --
| Thanks for the help
| Tonino