CFLib.org – Common Function Library Project

queryColumnToArray(query, column)

Last updated July 22, 2005
Download UDF

author

Peter J. Farrell                                  Peter J. Farrell

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:

<cfset qry = QueryNew("things,stuff") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "A") />
<cfset QuerySetCell(qry,"stuff", "a1") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "B") />
<cfset QuerySetCell(qry,"stuff", "b2") />
<cfset queryAddRow(qry)>
<cfset QuerySetCell(qry,"things", "C") />
<cfset QuerySetCell(qry,"stuff", "c3") />

<cfset my_array = queryColumnToArray(qry, "things") />
<cfdump var="#my_array#" />

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>

Search CFLib.org


Latest Additions

Shawn Porter Shawn Porter added
DeMoronize
2 hour(s) ago

Chris Carey Chris Carey added
readPropertiesFi...
1 day(s) ago

Randy Johnson Randy Johnson added
lastDayofWeek
3 day(s) ago

Frank Marion Frank Marion added
sitemapPing
7 day(s) ago

Top Rated

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Barney Boisvert indentXml
Rated 5.0, 3 time(s)

Nathan Dintenfass                                 queryColumnsToSt...
Rated 5.0, 3 time(s)

Kevin Pepperman generateSsccAsn
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson