CFLib.org – Common Function Library Project

Description:
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.

Return Values:
Returns a list.

Example:

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

<CFSET ColumnList = getQueryColumns(GetOrders)>

Parameters:

Full UDF Source:

/**
 * Returns list of query columns in order as defined by SQL query.
 * 
 * @param theQuery      Query object to examine. (Required)
 * @return Returns a list. 
 * @author James Moberg (james@ssmedia.com) 
 * @version 1, January 11, 2011 
 */
function getQueryColumns(theQuery){
    if(isQuery(theQuery)) return arraytoList(theQuery.getMeta().getColumnLabels());
    else return '';
}