CFLib.org – Common Function Library Project

Description:
Takes a selected column of data from a query and converts it into an array.

Return Values:
Returns an array.

Example:

<cfset qry = QueryNew("things,stuff") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "A") />
<cfset QuerySetCell(qry,"stuff", "a1") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "B") />
<cfset QuerySetCell(qry,"stuff", "b2") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "C") />
<cfset QuerySetCell(qry,"stuff", "c3") />

<cfset my_array = queryColumnToArray(qry, "things") />
<cfdump var="#my_array#" />

Parameters:

Full UDF Source:

<cfscript>
/**
 * Takes a selected column of data from a query and converts it into an array.
 * 
 * @param query 	 The query to scan. (Required)
 * @param column 	 The name of the column to return data from. (Required)
 * @return Returns an array. 
 * @author Peter J. Farrell (&#112;&#106;&#102;&#64;&#109;&#97;&#101;&#115;&#116;&#114;&#111;&#112;&#117;&#98;&#108;&#105;&#115;&#104;&#105;&#110;&#103;&#46;&#99;&#111;&#109;) 
 * @version 1, July 22, 2005 
 */
function queryColumnToArray(qry, column) {
	var arr = arrayNew(1);
	var ii = "";
	var loop_len = arguments.qry.recordcount;
	for (ii=1; ii lte loop_len; ii=ii+1) {
		arrayAppend(arr, arguments.qry[arguments.column][ii]);
	} 
	return arr;
}
</cfscript>