ColdFusion doesn’t like doublequotes in Query of Queries

Hello to anyone reading this!

I’ve decided to take my blog in a new direction, as I am now in web-development I’m going to begin to post problems I encounter and solutions I find(hopefully I find them) and try and breathe a little more life into the site, its been pretty stagnant of late!

Today I’ve discovered that ColdFusion really doesn’t like have quotation marks in query of queries. I got this rather unhelpful error:

Incorrect conditional expression,  Incorrect conditional expression,  Lexical error at line 0, column 0.  Encountered: "\"" (34), after : ""

Replacing the double quotes with single quotes fixed that problem, hope that helps someone!

Query of queries are great but are lacking in functionality, can’t do updates or deletes in them(I can see why but it is annoying!). I’ve found that I need to append the table name onto the start of each item in the query for it to work e.g.

SELECT test.username, test.id
FROM test
WHERE 1=1
GROUP BY test.id,test.username