problem is 12/12/2003 14.00.00 <> 12/12/2003 J
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 15:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] date functions in QoQ or in-memory sub queries I havent really used QoQ as I have never needed to but isnt it just : <cfquery dbtype="query" name="getevents"> SELECT label FROM [QUERYNAME] WHERE startdate = '12/12/2003 14.00.00' <cfquery> -----Original Message----- >From: Justin MacCarthy [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 15:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] date functions in QoQ or in-memory sub queries Can sound point me to a reference or example of using date function in QoQ (in-memory sub queries) if i have date in a query like this label startdate ------------------------------ something1 12/12/2003 5.00.00 something1 12/12/2003 14.00.00 and I want to query it for events that start on the 12/12/2003, how would I do it? What is available to me..? Thanks Justin -- ** 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] -- ** 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] -- ** 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]
