cfquery.columnlist order

[dizzyjay3268]

is there a way to have coldfusion return the results from a query in something other than alphabetical order? (like the order the items were selected perhaps? I have a JSON serializer and it runs through the query alphabetically.... I have the query results autobuilding a table but it always puts the columns alphabetically. Is there an option to return the columns in the order the sql is written

[-__cfSearching__- · Accepted solution]

Use the GetMetaData(yourQuery) function to return an array of column information. Then construct the desired column list from the returned array.