Fixed
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoftReporter
Adam Webster
Adam WebsterPriority
Labels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
None
Affects versions
Created 15 January 2020 at 03:17
Updated 27 April 2022 at 17:00
Resolved 7 April 2021 at 13:40
Variables.myQuery = QueryNew("myCol1, myCol2,myCol3", "varchar,varchar,varchar");
QueryAddRow(Variables.myQuery, 1);
QuerySetCell(Variables.myQuery, "myCol2", "some value", 1);
The space between the comma and the name of the second field will then cause an error that the query does not contain a field by that name. It is looking for " myCol2" and not "myCol2". ColdFusion ignores leading or trailing spaces between the field delimiter.