with lots of cf version what is the best way to get the quer cfml #cfml-general

with lots of cf version, what is the best way to g...

Simone

04/12/2022, 12:28 PM

with lots of cf version, what is the best way to get the query column names in same order and case whatever is specified in the sql query

adam.euans

04/12/2022, 12:54 PM

Copy code

q = queryNew('b,A,c','varchar,integer,varchar',[{a:1,b:'foo',c:'fooo'}]);
writeDump(q.getcolumnNames());

adam.euans

04/12/2022, 12:56 PM

and if you're using ACF you can use

Copy code

q.getMeta().getColumnLabels()