CFLib.org – Common Function Library Project

Description:
The function was inspired by the queryColumnToArray. It takes a query and a column as arguments and returns a list.

Return Values:
Returns a list.

Example:

<cfset qry = QueryNew("Column1,Column2") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"Column1", "A") />
<cfset QuerySetCell(qry,"Column2", "A1") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"Column1", "B") />
<cfset QuerySetCell(qry,"Column2", "B2") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"Column1", "C") />
<cfset QuerySetCell(qry,"Column2", "C3") />

<cfset theList = queryColumnToList(qry, "Column1") />
<cfdump var="#theList#" />

Parameters:

Full UDF Source:

/**
 * Takes a selected column of data from a query and converts it into a list.
 * 
 * @param qry      Query to use. (Required)
 * @param column      Column to use. (Required)
 * @param delim      Delimiter. Defaults to a comma. (Optional)
 * @return Returns a list. 
 * @author Randy Johnson (randy@cfedge.com) 
 * @version 1, January 4, 2007 
 */
function queryColumnToList(qry, column) {
    var theList = "";
    var counter = "";
    var num_rows = arguments.qry.recordcount;
    var delim = ",";
    if(arrayLen(arguments) gte 3) delim = arguments[3];
    for (counter=1; counter lte num_rows; counter=counter+1) theList = listAppend(theList, arguments.qry[arguments.column][counter],delim);
    return theList;
}