Hi all, I have the following query, trying to pull out login attempts that have occurred within the past 24 hours:
SELECT attempt.pkAttempt FROM attempt WHERE attempt.ipaddress = '#cgi.remote_addr#' AND attempt.type = '#attributes.type#' AND attempt.dtAttempt BETWEEN DATEADD(hh,24,GETDATE()) AND GETDATE() It's not throwing an error, but it's not returning results that it definitely should be, either. Can anyone see where I'm going wrong? (SQL Server 2000) Thanks, Kay. ______________________________________________________ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Level 9/105 St George's Terrace - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au http://developer.perthweb.com.au - Tools for Developers cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
