local.q_asset = queryNew('asset,asset_id');
<cfquery name="qTest" dbtype="query">
select asset, asset_id
group by asset, asset_id
order by asset
throws the following error
Lexical error at line 2, column 17. Encountered: "[" (91), after : ""
this works fine in ACF
I think the brackets [ ] should just be parsed as whitespace?
Yes, I've tested with both mySql & SqlServer. It throws the same error.
Works for me on Lucee 4.5.3.020, 5.6.35-log, Linux - 2.6.32-431.29.2.el6.x86_64, after fixing the error in the test code provided in the original description .
There's no 'asset_id' column, columns are asset and id.
also solved by
fixed by the QoQ update