Query of Query HELP

[Schreck, Tom]

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\dsp_ShellCalendar.cfm: line 94 Called from C:\Inetpub\wwwroot\Codebase\ElectronicAccountant\Index.cfm: line 40 Called from C:\Inetpub\wwwroot\Codebase\ElectronicAccountant\Display\dsp_ShellCalendar.cfm: line 94 Called from C:\Inetpub\wwwroot\Codebase\ElectronicAccountant\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 < &apos;2/1/2003&apos; ORDER BY txtContentHeader     Looks like it changes the single quotes to “&apos;” 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