Can anyone think of a way to create a query object...
# testinga
aliaspooryorik
02/10/2022, 12:37 PM
Can anyone think of a way to create a query object which has spaces in the column names? Backfilling tests on some old code before I refactor and it seems that cfspreadsheet when reading to a query object will handle spaces in column names which I want to mock.
w
wil-shiftinsert
02/10/2022, 12:44 PMquerynew("this has spaces,thisOneNot")a
aliaspooryorik
02/10/2022, 12:44 PM
tried that - Lucee works, ACF does not.
aliaspooryorik
02/10/2022, 12:45 PM
Also tried QuerySim in mockbox and throws an error
aliaspooryorik
02/10/2022, 12:45 PM
QueryAddColumn with a column with spaces also errors on ACF
aliaspooryorik
02/10/2022, 12:57 PM
This looks like the trick https://blog.simplicityweb.co.uk/125/renaming-cfml-query-columns
aliaspooryorik
02/10/2022, 12:59 PM
That Adam Cameron chap has the smarts.
➕ 1
w
wil-shiftinsert
02/10/2022, 1:00 PMOk, interesting. 1-0 for lucee in this case
a
Adam Cameron
02/10/2022, 1:15 PM
That Adam Cameron chap has the smarts.That seems unlikely.
a
aliaspooryorik
02/10/2022, 3:46 PM
ha 🙂 You constantly make me realise that I know very little.
a
Adam Cameron
02/10/2022, 6:42 PM
I know some different things from you maybe, that is all.