Surprising Error with QofQ in CF 5

[waterworker]

Has anyone seen this error? I don't understand why I can get the below QofQ
code to work properly on my personal developer CF MX server but I can't make it
work on my Department's enterprise CF 5 server? To me, it seems like the CF 5
server doesn't understand how to process a QofQ. Any thoughts? Thanks.

Here is the error:

Query Manipulation Error Code = 0
Invalid SQL
SQL = "SELECT test1.* FROM test1;"
Data Source = ""

Here is the code:

<cfquery NAME="test1" datasource="#REQUEST.DSN#">
SELECT CNY_COUNTY.*
FROM CNY_COUNTY;
</cfquery>

<cfloop QUERY="test1">
#CNY_NAME#<br />
</cfloop>

<cfquery NAME="test2" DBTYPE="QUERY" >
SELECT test1.*
FROM test1;
</cfquery>

<cfloop QUERY="test2">
#CNY_NAME#<br />
</cfloop>

[paross1]

Q-of-Q first became available with CF 5, and it doesn't look like you are doing
anything that wasn't supported in that version, except that you should get rid
of the trailing semicolon at the end of your query (;).

Phil

[waterworker]

Thanks for the quick response. I tried removing the semicolon and got the same error. Any other thoughts?

[paross1]

Here is the CF 5 LiveDocs page for
[url]http://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applications[/url]
/queryDB11.htm#1117238

Try removing the table name prefix from your select, or select explicit
column names from your first query rather than SELECT * ?

<cfquery NAME="test2" DBTYPE="QUERY" >
SELECT *
FROM test1
</cfquery>

Phil

[waterworker]

Thanks for the help.