CFLib.org – getQueryColumns

getQueryColumns(theQuery)

Last updated January 11, 2011

author

Version: 1 | Requires: ColdFusion MX | Library: DatabaseLib

Rated 1 time(s). Average Rating: 5.0

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:

view plain print about

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

<CFSET ColumnList = getQueryColumns(GetOrders)>

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

<CFSET ColumnList = getQueryColumns(GetOrders)>

Parameters:

Name	Description	Required
theQuery	Query object to examine.	Yes

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<cfscript>
/**
 * 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 (&#106;&#97;&#109;&#101;&#115;&#64;&#115;&#115;&#109;&#101;&#100;&#105;&#97;&#46;&#99;&#111;&#109;) 
 * @version 1, January 11, 2011 
 */
function getQueryColumns(theQuery){
	if(isQuery(theQuery)) return arraytoList(theQuery.getMeta().getColumnLabels());
	else return '';
}
</cfscript>
		<cfscript>
/**
 * 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 '';
}
</cfscript>