Highlighted

ColdFusion 11 - QoQ semicolon = bad?

Community Beginner ,
Jun 20, 2014

Copy link to clipboard

Copied

I just (literally) installed CF11 (in production) -- just kidding, locally of course and started testing it.   I noticed right away that the QoQ that used to run in CF10 are breaking... and it's because the SQL statements contains a semicolon at the end of them. (e.g)

<cfquery name="qNew" dbtype="query">

  SELECT ID, Name from myOrigQuery where ID = 50;

</cfquery>

The error I've been getting is something like

"<br><b>Query Of Queries runtime error.</b><br> The select column reference [50;] is not a column in any of the tables of the FROM table list."

If I remove that semicolon, then it works fine. Is this a change? Is there a new setting in CF Admin that prevents this problem? CF 11 just came out, so googling doesn't show much of anything.... or my search criteria is not any good   I did try to search the forum if anyone has encountered it yet, but didn't find anything.

Views

371

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

ColdFusion 11 - QoQ semicolon = bad?

Community Beginner ,
Jun 20, 2014

Copy link to clipboard

Copied

I just (literally) installed CF11 (in production) -- just kidding, locally of course and started testing it.   I noticed right away that the QoQ that used to run in CF10 are breaking... and it's because the SQL statements contains a semicolon at the end of them. (e.g)

<cfquery name="qNew" dbtype="query">

  SELECT ID, Name from myOrigQuery where ID = 50;

</cfquery>

The error I've been getting is something like

"<br><b>Query Of Queries runtime error.</b><br> The select column reference [50;] is not a column in any of the tables of the FROM table list."

If I remove that semicolon, then it works fine. Is this a change? Is there a new setting in CF Admin that prevents this problem? CF 11 just came out, so googling doesn't show much of anything.... or my search criteria is not any good   I did try to search the forum if anyone has encountered it yet, but didn't find anything.

Views

372

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 20, 2014 0

Have something to add?

Join the conversation