|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Date Diff Routine |
|
From: |
Jordi |
|
Date: |
12/24/2003 4:44:24 AM |
|
IP: |
195.77.33.58 |
Sorry, i hadn't finished...
'This SQL selects all calls that differs 4 hours from now. See more information about DateDiff in SQLServer
sql = "select IDCALL FROM Calls WHERE datediff(hh, columntime, getdate())>4 "
set rst = objconnection.execute(sql)
while not rst.eof
sql = "update call set field=1 where idcall=" & rst("IDCall")
objconnection.execute(sql)
rst.movenext
wend
rst.close |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
