Lee's Code: Classic ASP Timer using SQL Server

Lee's Code A web programmer's toolbox.

SEARCH SITE

HOME | ABOUT LEE | CONTACT | SEARCH

Navigation

ASP Code and Tips
CSS Code and Tips
HTML Code and Tips
JavaScript
RSS Code and Tips
T-SQL Scripts and Tips
XML Code and Tips

Lee's Code RSS Feed

Latest Additions

ASP - Create Radio But...
Extract XSD Date and T...
Convert DateTime to XS...
Form Button Working an...
Refresh Opening Page...

Links

Recommendations

Evolve Online

Powered by
Evolve Online

Classic ASP Timer using SQL Server

By: Lee A. Shurie
Subject:	ASP: Timer
Language:	ASP
Rating:	Rated 59 times. Rate or review this item: 1 2 3 4 5
Information This script provides a way to cause your Classic ASP page t pause or sleep. It uses SQL Server to perform the sleep function.
Code <% '<!-- Written by Lee A. Shurie, le@vgrp.com --> '<!-- This script uses SQL Server to sleep or pause your Classic ASP page --> '<!-- Output the page without buffering --> Response.Buffer = false '<!-- Setup the time to sleep --> varHours = "00" 'Up to 99 hours varMinutes = "00" 'Up to 59 minutes varSeconds = "10" 'Up to 59 seconds varTimeout = (clng(varHours) * 3600) + (clng(varMinutes) * 60) + clng(varSeconds) + 5 '<!-- Open the database connection --> Set c = CreateObject("ADODB.Connection") c.Open "driver={SQL Server};server=myDatabaseServer;database=myDatabase","myLogin","myPassword" '<!-- make sure timeout doesn't expire --> c.commandTimeout = varTimeout '<!-- Execute the SQL statement which does the work --> Response.Write "<strong>This page will sleep for " & cInt(varHours) & " hours, " & cInt(varMinutes) & " minutes, " & cInt(varSeconds) & " seconds.</strong><br> <br>" & vbCRLF Response.Write "> Starting to sleep at: " & Now() & "<br>" & vbCRLF Response.Write "> I am now sleeping...<br> <br>" & vbCRLF sql = "WAITFOR DELAY '" & right(clng(varHours), 2) & ":" & right(clng(varMinutes), 2) & ":" & right(clng(varSeconds), 2) & "'" c.Execute sql,,129 Response.Write "> Waking up at: " & Now() & "<br>" & vbCRLF Response.Write "> I am now awake." & vbCRLF '<!-- Cleanup --> c.close Set c = Nothing %>
Instructions Simply copy this code and change the sql server connection string to connect to your database. Set the number of hours, minutes, and seconds you want the page to sleep.
Keywords:Classic ASP Timer using SQL Server


	HOME \| ABOUT LEE \| CONTACT \| SEARCH

Copyright © 2001 - 2010 by Lee A. Shurie