Database 2002

  • Thread starter Thread starter Ralph
  • Start date Start date
R

Ralph

I am using Front Page 2002.

I want to run a database on our website. It has eight
fields and I want the visitor to be able to select data
from each field and end up with what he is looking for.

I have put each query on an ASP page and sent the criteria
with the hyperlinks to the next query, etc. Using simple
queries this works fine, but I want to run distinct
queries so I do not have data repeated many times in each
result. My problem is that with distinct queries I do not
have the previous data to send forward.

I set all the queries up on a single ASP Page. When I run
the queries the data gets to all of them, but when I
continue running the queries the previous data is lost.
This would work if I could recycle the data in the field
form until the last query is run. Is that possible in
Front Page?

Is there anything new on database in Front Page 2003 that
would help me?

Thanks for your help.
 
Hi Ralph,

What is required is a method to persist the information from one form
submission to the next. There are several options available:

Use session variable as in

session("field1") = request.form("field1")

Store the value as a hidden field value in to the next form

<input type="hidden" name="Field1" vlaue="<% =request.form("field1") %> >

Store the values into a cookie

response.cookies("Field1") = request.form("field1")
 
Thanks for the information on Sessions, I'm still reading
about them. I've had limited programming experience. In
the early 80's I did the programming in Basic for a remote
signal measuring system at NBC.

For this reason I need more help:

Do I have to insert the information in the source code or
can it be done in Front Page?

Also, can I link two hyperlinks together so by clicking on
one it will run the query and retrieve a new page and at
the same time run a hidden query on the same ASP page?

Thank you for your help!
 
Hi Mike:

Thanks for the inforamtion on Sessions, I'm still reading
about them. I've had limited programming experience . In
the early 80's I did the programming in Basic for a remote
signal measuring system at NBC.

For this reason I need more help:

Do I have to insert the information in the source code or
can it be done in Front Page?

Also, can I link two hyperlinks together so by clicking on
one it will run the query and retrieve a new page and at
the same time run a hidden query on the same ASP page?

Thank you again for your help!!!
 
You have to manually code/insert them in HTML view.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Back
Top