Initial query:
<cfquery name="qoqOrdinalDayEvents" dbtype="query">
SELECT numContentID, txtContentHeader, dtStart,
dtEnd
FROM qryGetContentList
WHERE dtStart <
#createODBCDate(variables.OrdinalDay)#
ORDER BY txtContentHeader
</cfquery>
I used IsDate() to see if variables.OrdinalDay is a date and it tested
true. I tried #createODBCDate()# and would get this error:
Error Occurred While Processing Request
Error Executing Database Query.
Query Of Queries syntax error.
Encountered "dtStart < {" at line 4, column 31. Incorrect conditional
expression, Expected one of [like|null|between|in|comparison] condition,
Returned SQL Statement in Error Message:
SQL SELECT numContentID, txtContentHeader, dtStart, dtEnd
FROM qryGetContentList WHERE dtStart <{d '2003-02-01'}
ORDER BY txtContentHeader
Thanks - Tom
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:49 AM
To: [EMAIL PROTECTED]
Subject: Re: Query of Query HELP
Sounds like it's not recognizing the '2/1/2003' as a date -- or it's not
recognizing the dtStart column as a date, but I'd bank on the former.
You
might try using #createODBCDate()# -- just a guess.
> I'm migrating a CF5 app to MX and am having difficulty
> getting a Query
> of Query to work in MX. Here's my Query of Query:
> <cfquery
> name="qoqOrdinalDayEvents"
> dbtype="query">
> SELECT numContentID,
> txtContentHeader, dtStart, dtEnd
> FROM qryGetContentList
> WHERE dtStart <
> '2/1/2003'
> ORDER BY
> txtContentHeader
> </cfquery>
> The error message is:
> Error Occurred While Processing Request
> Error Executing Database Query.
> Query Of Queries runtime error.
> Unsupported type comparison.
> The error occurred in
> C:\Inetpub\wwwroot\Codebase\ElectronicAccountant\Display\d
> sp_ShellCalend
> ar.cfm: line 94
> Called from C:\Inetpub\wwwroot\Codebase\ElectronicAccounta
> nt\Index.cfm:
> line 40
> Called from
> C:\Inetpub\wwwroot\Codebase\ElectronicAccountant\Display\d
> sp_ShellCalend
> ar.cfm: line 94
> Called from C:\Inetpub\wwwroot\Codebase\ElectronicAccounta
> nt\Index.cfm:
> line 40
> 92 : --->
> 93 : ORDER BY
> txtContentHeader
> 94 : </cfquery>
> 95 :
> 96 : <cfdump
> var="#qoqOrdinalDayEvents#">
> ----------------------------------------------------------
> --------------
> --------
> SQL SELECT numContentID, txtContentHeader, dtStart,
> dtEnd FROM
> qryGetContentList WHERE dtStart < '2/1/2003'
> ORDER BY
> txtContentHeader
> Looks like it changes the single quotes to "'" and is
> causing the
> SQL to not work. I've tried setting the Select statement
> to a string
> then use PreserveSingleQuotes() function in the Query of
> Query cal, but
> to no avail. Any help would save the few hairs I have on
> my head.
> Thanks -
> Tom Schreck
> 817-252-4900
> [EMAIL PROTECTED]
> I have not failed. I've found 10,000 ways that won't
> work.
> - Thomas Edison
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
