Auto refreshing data on asp page

x_ray · #1 (**permalink**) December 3rd, 2005, 06:08 AM

hi all,
i have an asp page that generates results depending on a user input. the problem is that when many users are updating the databse, i want the asp page to refresh itself when the database is updated or, if this is not possible,to refresh itself say every 3 minutes.
Note: i am using javascript with asp, and SQL server 2000.
i would appreciate any reply,

Steven · #2 (**permalink**) December 4th, 2005, 05:15 PM

are you assuming that a user will have your page open continuously for more than 3 minutes (which would probably be unlikely)? If so, you could use a meta refresh:

Code:

<META HTTP-EQUIV=Refresh CONTENT="180">

Otherwise, the data should refresh every time the user opens the page.
To let the users know how up to date / out of date the data is, you could put the date & time on the page, such as:

Code:

<p>Page created at <% =Now() %>. <a href="#">Refresh</a></p>

I am a loud man with a very large hat. This means I am in charge

x_ray · #3 (**permalink**) December 7th, 2005, 07:00 AM

Quote:

quote:Originally posted by Steven
are you assuming that a user will have your page open continuously for more than 3 minutes (which would probably be unlikely)? If so, you could use a meta refresh:

Code:

<META HTTP-EQUIV=Refresh CONTENT="180">

Otherwise, the data should refresh every time the user opens the page.
To let the users know how up to date / out of date the data is, you could put the date & time on the page, such as:

Code:

<p>Page created at <% =Now() %>. <a href="#">Refresh</a></p>

I am a loud man with a very large hat. This means I am in charge

thanks a lot steven for both tips, i will try them and let you know(although sure they will gonna work)

Need to download code?

Navigation