Retrieve a list of column names in the order as defined by SQL for use with CFSpreadsheet (generating a header row) and other loop functions.

getQueryColumns.cfm

<cfscript>
  function getQueryColumns(theQuery){
    if(isQuery(theQuery)) return arraytoList(theQuery.getMeta().getColumnLabels());
    else return '';
  }
</cfscript>

<!--- Example --->
<cfquery name="GetOrders">
  SELECT orderid, customerfirstname, customerlastname, total
  FROM orders
  ORDER BY orderid
</cfquery>

<cfset ColumnList = getQueryColumns(GetOrders)>