sample. If I have a DB query that I name "usage" and then try and do a QoQ
against it, I get an MX error when using an Oracle 8i/9i database (I don't
have SQL Server, so I can't test against that).
Code Sample:
<cfquery name="usage" datasource="myDSN">
SELECT sysdate AS theDate
FROM dual
</cfquery>
<cfquery name="buildUsage" dbtype="query">
SELECT *
FROM usage
</cfquery>
<cfdump var="#usage#" expand="No">
<cfdump var="#buildUsage#" expand="No">
will yield:
<br><b>Query Of Queries syntax error.</b><br> Encountered "usage" at line 0,
column 0.
However, if I change the query name "usage" to "usage2", everything works
fine. I search LiveDocs and don't see any mention of reserved words. I just
wanted to see if anybody can confirm what I'm seeing and/or confirm that
this is unexpected behavior before I post a bug.
My setup is: JRun Updater 2 running MX Enterprise 6.1.
Perhaps somebody could run this on the standalone version to see if there's
a difference?
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
