CFLib.org – Common Function Library Project

Description:
Converts a query to a structure of structures with the primary index of the main structure auto incremented. Thanks to Shawn Seley's QueryToStructOfStructures for the basis of my code.

Return Values:
Returns a struct.

Example:

<cfquery name="test" datasource="test">
select * from test
</cfquery>

<cfset s = queryToStructOfStructsAutoRow(test)>

Parameters:

Full UDF Source:

/**
 * Converts a query to a structure of structures with the primary index of the main structure auto incremented.
 * 
 * @param theQuery      The query to transform. (Required)
 * @return Returns a struct. 
 * @author Peter J. Farrell (pjf@maestropublishing.com) 
 * @version 1, September 23, 2004 
 */
function queryToStructOfStructsAutoRow(theQuery){
    var theStructure = StructNew();
    var cols = ListToArray(theQuery.columnlist);
    var row = 1;
    var thisRow = "";
    var col = 1;
    
    for(row = 1; row LTE theQuery.recordcount; row = row + 1){
        thisRow = StructNew();
        for(col = 1; col LTE arraylen(cols); col = col + 1){
            thisRow[cols[col]] = theQuery[cols[col]][row];
        } 
        theStructure[row] = Duplicate(thisRow);
    } 
    return theStructure;
}