> problem is 12/12/2003 14.00.00 <> 12/12/2003 If QoQ supports BETWEEN, wrap the two date/time objects in cfqueryparam.
To be honest, I suspect that wrapping the date/times in quotes works as, at some level, ColdFusion's date/time objects will be held in memory as a string, so the text comparison succeeds on identical date/times, but it can't be good practise, plus you come unstuck when you want to isolate a portion of the date/time object in the WHERE clause. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
