CFLib.org – queryColumnToArray

queryColumnToArray(query, column)

Last updated July 22, 2005

Download UDF

author

Peter J. Farrell
Send Email

Version: 1 | Requires: ColdFusion 5 | Library: DataManipulationLib

Rated 0 time(s). Average Rating: 0

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

Return Values:
Returns an array.

Example:

Parameters:

Name	Description	Required
query	The query to scan.	Yes
column	The name of the column to return data from.	Yes

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 (pjf@maestropublishing.com) 
 * @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>