Database update

Setting up a scheduled task is the solution, there is nothing coding asp-wise that can be done to make sure its done on the hour...

but your method is pretty good..... if no one is there to see the page and an update doesn't happen, it well upon next hit

The best way to do with asp would be to work your code so that it checks how much time is passed since the last time this function has run.  If it has been an hour, then it can do the updating before it does anything else.  If it has been more than an one hour, make it call the update repeatedly until it has caught up with the number of hours pasted.  Otherwise do nothing.  You could possible create something within an sql server to do that, a task per se, but I wouldn't know how to do that, and if you already know asp, it's a hassle to learn something else when you can do with asp.  ASP can only run when it is called.  It's compiled whenever someone tries to access the page in question.  Unless you have IIS setup with caching.  I hate caching.  *shudder*  That means it saves your ASP basically, so that it will compile only once for 10+, 100+, or more runs, and it will not update itself from the asp file until it has been called that many times.

thats correct... because since IIS and serving up ASP pages is a passive thing, requiring some sort of action against it... there is no ability to natively run a task at a given time

as mentioned (and it appears you even remotely looked into it), there is a "Scheduled task" available that would do this.. but its up to you to spend a little effort to see if its doable

as for caching.. there's good times and bad times for it

ohk thanks Michael.