Switch the 2 dates:-) -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 3:04 PM To: SQL Subject: BETWEEN and date functions
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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
