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
