ColdFusion · Database exception
What does Query Of Queries syntax error mean in ColdFusion?
Query of Queries (QoQ), ColdFusion's feature for running SQL-like statements against an in-memory query object, implements only a small subset of SQL-92. A common trigger is a column name that happens to be a QoQ reserved word, such as FIRST or LAST, which a source file (an uploaded spreadsheet, for instance) can easily produce without anyone intending it.
Query of Queries (QoQ), ColdFusion's feature for running SQL-like statements against an in-memory query object, implements only a small subset of SQL-92. A common trigger is a column name that happens to be a QoQ reserved word, such as FIRST or LAST, which a source file (an uploaded spreadsheet, for instance) can easily produce without anyone intending it.
Check whether a failing column name is a QoQ reserved word, and if so, enclose it in double quotes in the QoQ statement, or rename the column before running the in-memory query against it.