Practical Programming

«« Back to ColdFusion Library

Category:
   QUERY

Description:
   Copies the specified column of a query into an array

Parameters:

1. query (Query, required)
          The query you are working with
   
   
2. column (String, required)
          A column from the query
   
   

Returns:
       

Requires:
       

Sample Use:
       

Copy to Clipboard

function queryArray(query,column){
	var loop = 0;
	var value = arrayNew(1);
	for (loop = 1; loop lte query.recordCount; loop = incrementValue(loop)){
		value[loop] = query[column][loop];
	};
	return value;
}
// http://www.programmers.org/index.php/coldfusion-udf-library/?ckey=61&function=queryArray

function queryArray(query,column){ var loop = 0; var value = arrayNew(1); for (loop = 1; loop lte query.recordCount; loop = incrementValue(loop)){ value[loop] = query[column][loop]; }; return value; } // http://www.programmers.org/index.php/coldfusion-udf-library/?ckey=61&function=queryArray