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]
