p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   Updating table every now and then (http://p2p.wrox.com/showthread.php?t=35572)

rtr1900 November 29th, 2005 12:22 PM

Updating table every now and then

Is there a way I can give a command it will execute an SQL Syntax every x minutes?
I need to update a table every x minutes with new data from other tables....

I thought of executing a page every x minutes from the page the user is watching the data.

Can this be done?



ChrisScott December 1st, 2005 02:22 PM

Hi David,

Could you create the file as a vbs / js / wsf script file and execute it using the windows task scheduler on the server?



rtr1900 December 2nd, 2005 03:12 AM

Hi Chris,

I will take a look at it. At this moment I tried the next:

Created an ASP Page which contains the SQl Syntax and in the <HEAD> I have a refresh command for every 120 secs. So this way it will update the table with new data.

This page will be executed on the server.... Still it isn´t the best way, but works. Maybe I will make a little EXE in Powerbuilder and run it in the sheduler on the server

Thx for the great idea!



All times are GMT -4. The time now is 04:24 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.