a date query question

[mike2004]

I have this update query: UPDATE AccountsIpLogs SET LoggedIn = '0' I would
like to add below WHERE statement but I don't know how to write it: I want to
set LoggedIn equal to Zero where TheDate field is 15 minutes older than Now()
date and time. Basically this query will run every 15 minutes to identify
logged out clients. Any help would appriciate. Thanks, Mike

[vkunirs]

Hi

use the datediff to find the sec

[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi58.htm[/url]

or else you can directly write in the query itself like

UPDATE AccountsIpLogs
SET LoggedIn = '0'
where datediff(logindate,now())>15 sec.

you can do this way also. here i have not written the correct syntax. but you
can do this way also, no need of cf.

[mike2004]

Thank you vkunirs.

Mike

[mike2004]

Do I need to say MAX(logindate) on SELECT?