Is there a way to have SQL server pass a HTML string...

[DougP]

Is there a way to have SQL server pass a HTML string out to the Internet at a specified time?

I would like to pass information to a WEB site based on times in a table
such as
So the system clock would look in a table every 5 minutes
and see if a time is going to go by in the next 4 minutes 59 seconds. If there is a record then send the HTML out through a browser or something

http://www.mysite.com/myasp.asp?A=1234&B=abcde&C=zyx

Now the HTML parameters would be different

Example Table

Date Time A-Value B-Value C-Value
4/6/01 19:34 3425 erww speh
4/6/01 20:15 2933 sdfe okjd
4/7/01 1:15 9288 desr wiuw

So at 19:34 it would send out this string

http://www.mysite.com/myasp.asp?A=3425&B=erww&C=speh

at 20:15 this string

http://www.mysite.com/myasp.asp?A=2933&B=sdfe&C=okjd

at 1:15 this string

http://www.mysite.com/myasp.asp?A=9288&B=desr&C=wiuw

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive