|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
