CFLib.org – Common Function Library Project

Description:
A quick way to get the variables in one row of a query into local variables (or any other scope). You pass in a query and the variables are created based on the column names in the query. You can also optionally specify a scope and a row in the query to use.

Return Values:
Returns an empty string.

Example:

<cfscript>
	//make a simple query
	q = queryNew("fname,lname");
	queryAddRow(q,2);
	querySetCell(q,"fname","Jedi",1);
	querySetCell(q,"lname","Master",1);
	querySetCell(q,"fname","Ben",2);
	querySetCell(q,"lname","Archibald",2);	
	//make local variables
	queryToVars(q);
	//now, put the second row into the request scope
	queryToVars(q,"request",2);
</cfscript>
<!--- output the variables to the screen --->
<cfoutput>
	#fname# #lname#<br>
	#request.fname# #request.lname#
</cfoutput>

Parameters:

Full UDF Source:

<cfscript>
/**
 * Change a row in a query to variables in a scope.
 * 
 * @param q 	 The query to use. 
 * @param scope 	 Scope to save data in. Defaults to "" or local scope. 
 * @param row 	 Row number to use. Defaults to 1. 
 * @return Returns an empty string. 
 * @author Nathan Dintenfass (&#110;&#97;&#116;&#104;&#97;&#110;&#64;&#99;&#104;&#97;&#110;&#103;&#101;&#109;&#101;&#100;&#105;&#97;&#46;&#99;&#111;&#109;) 
 * @version 1, March 11, 2002 
 */
function queryToVars(q){
	//first, an array of the column names for looping
	var cols = listToArray(q.columnList);
	//a var to use as iterator
	var ii = 1;
	//by default, use no scope
	var scope = "";
	//by default, use the first row
	var row = 1;
	//if there is a second argument, use that as the scope
	if(arrayLen(arguments) GT 1)
		scope = arguments[2] & ".";
	//if there is a third argument and it is numeric, use that as the row (make sure it is a positive integer)
	if(arrayLen(arguments) GT 2 and isNumeric(arguments[3]))
		row = ceiling(abs(arguments[3]));		
	//loop over the columns, making a variables for each one
	for(ii = 1; ii lte arrayLen(cols); ii = ii + 1)
		setVariable(scope & cols[ii],q[cols[ii]][row]);
	//return nothing
	return "";	
}
</cfscript>