CFLib.org – Common Function Library Project

Description:
The CFML function, ValueList, does not allow you to grab a column dynamically unless you use the evaluate function. This UDF allows you to grab a list of values from one particular column.

Return Values:
Returns a list.

Example:

<cfset test = queryNew("name,age")>
<cfloop index="x" from=1 to=5>
	<cfset queryAddRow(test)>
	<cfset querySetCell(test,"name","Random Name #randRange(1,10000)#")>
	<cfset querySetCell(test,"age","#randRange(1,100)#")>
</cfloop>
<cfdump var="#test#">
<cfdump var="#DynamicValueList(test,"name")#">

Parameters:

Full UDF Source:

<cfscript>
/**
 * Returns a value list from a dynamic column of a query.
 * 
 * @param query 	 The query to examine. (Required)
 * @param col 	 The column to return values for. (Required)
 * @param delim 	 Delimiter. Defaults to comma. (Optional)
 * @return Returns a list. 
 * @author Raymond Camden (&#114;&#97;&#121;&#64;&#99;&#97;&#109;&#100;&#101;&#110;&#102;&#97;&#109;&#105;&#108;&#121;&#46;&#99;&#111;&#109;) 
 * @version 1, August 14, 2002 
 */
function DynamicValueList(query,col) {
	var delim = ",";
	if(arrayLen(arguments) gte 3) delim = arguments[3];
	return arrayToList(query[col],delim);
}
</cfscript>