HI, For the last week or so I have been using a query-of-query happily... Everything has worked.. and it has saved about 25 or more round trips to the database.
Today on a different test machine, the page no longer works. The query to populate the query is: <cfquery datasource="#attributes.dsn#" name="DATE_RANGE"> SET DATEFORMAT DMY SELECT DISTINCT CONVERT(DATETIME, CONVERT(VARCHAR, SB_SERVICE_DATE,103)) AS SERVICE_DAY FROM SB_CONING_RUN WHERE SB_SCHEDULE_FEE IS NOT NULL AND SB_CONING_RUN_NO = <cfqueryparam cfsqltype="cf_sql_varchar" value="#variables.unique_id#"> ORDER BY SERVICE_DAY </cfquery> And I would like to use it thus: <!--- Loop over the date range query ---> <CFLOOP query="DATE_RANGE"> <!--- Select all items for the given date ---> <CFQUERY dbtype="query" name="MYOCARDIAL_PERFUSION_STUDIES"> SELECT SB_CONING_ID, SB_ITEM_NUMBER, SB_CONING_ERROR FROM CONING_RECORDS WHERE SERVICE_DAY = '#DATE_RANGE.SERVICE_DAY#' </CFQUERY> </cfloop> However I recieve the following error: Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. The error occurred in C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1205 Called from C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1193 Called from C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1 Called from C:\Inetpub\wwwroot\Bilby\test_coning.cfm: line 8 Called from C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1205 Called from C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1193 Called from C:\Inetpub\wwwroot\Bilby\apply_coning.cfm: line 1 Called from C:\Inetpub\wwwroot\Bilby\test_coning.cfm: line 8 1203 : CONING_RECORDS 1204 : WHERE 1205 : SERVICE_DAY = '#DATE_RANGE.SERVICE_DAY#' 1206 : </CFQUERY> 1207 : Both Service Day fields are dates without any time portion. 2004-05-13 00:00:00.000 The query has worked without a problem until changing to the new machine ...... Can anyone help? Im Running CFMX 6.1 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
