Refresh rate for database

[Chris van den Heever]

Hi
I wonder if any one has a solution for me

I created a series of three pages 1 2 3
page one collects results and is sent to an asp db.1
page two then uses the dbresults from aspdb.1 and another text input area
which is sent to db.2

This works fine with one exception
The input does not display in the result field until the "refresh" button is
clicked.

Now the question
Is there any way of setting the page to automatically requery the database
or to automatically refresh the page.

Thanks for your time
Chris van den Heever

 

[Thomas A. Rowe]

You have to make another query to the database to see all of the update info or refresh the page.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Chris van den Heever]

Thanks.
Would I then use the query to base the "Results area on"

 

[Chris van den Heever]

Ok tried that and it does not work
Any other options maybe an easy script?

 

[Thomas A. Rowe]

Not really sure how you are getting data on to page 1 and then passing it to page 2, and then what
happen after page two for you to see it on page 3.

Can you explain this in more detail, step by step? Then I or someone else may be better able to help
you.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Chris van den Heever]

Hi
I wonder if any one has a solution for me

I created a series of three pages 1 2 3
page one collects results and is sent to an asp db.1
page two then uses the dbresults from aspdb.1 and another text input area
which is sent to db.2

This works fine with one exception
The input does not display in the result field until the "refresh" button is
clicked.

Now the question
Is there any way of setting the page to automatically requery the database
or to automatically refresh the page.

.............................................................................
............Full
explanation:................................................................
...................................

Page 1 is an asp base from with a text area.Visitors type in the text click
submit
Data sent to db.1
Page 2(asp) A results area from db1 which lists the data in a selected field
in in a dropdown box allowing visitors to click a selection .This is
followed by a text area wich allows the visitor to type in more data and
then hit submit.
Data sent to db. 2
Page (3) follows the same input format using a selection from a column in
db.2 and a new text box

The full results are displayed in another part of the web

However, you have to use the refesh button to recall the data from the
database.

What I need is to have the page and data refresed automatically

 

[Chris van den Heever]

Have posted the full explanation in first posting

Not really sure how you are getting data on to page 1 and then passing it to page 2, and then what
happen after page two for you to see it on page 3.

Can you explain this in more detail, step by step? Then I or someone else may be better able to help
you.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Thomas A. Rowe]

Ok, let see if I got this right...

Page 1 user add data and submit data to a table in the database

Page 2 automatically retrieves the data entered in Page 1 from table 1 in the database, user add
additional data and submits data to table 2 in the database

Page 3 automatically retrieves the data entered in Page 2 from table 2 in the database, use add
additional data and submits data to....database

Page 4 automatically retrieves the data entered in Page 3 from....database

Treat Page 4 as a confirmation page
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Chris van den Heever]

Yes That's it but the options do not list in the results unless "refresh
"button is clicked
can this be automated
Once again thanks for the effort to help me

 

[Thomas A. Rowe]

On your last page you have to go back to the database, either by forcing a query when the page loads
or going to a final page, as I don't think you would want to do meta refresh, as that would cause
the page to constantly refresh at whatever rate you set, even if the content hasn't changed.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================