|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
