Here's another one if you want to turn the query variable into an array of structures.

view plain print about
1array function queryToArray (required query data)
2    output="false"
3{
4    local.columns = listToArray(arguments.data.columnList);
5
6    local.queryArray = [];
7
8    for (local.rowIndex = 1; local.rowIndex <= arguments.data.recordCount; local.rowIndex++) {
9        local.row = {};
10
11        for (local.columnIndex = 1; local.columnIndex <= arrayLen(local.columns); local.columnIndex++) {
12            local.columnName = local.columns[local.columnIndex];
13
14            local.row[local.columnName] = arguments.data[local.columnName][local.rowIndex];
15        }
16
17        arrayAppend(local.queryArray, local.row);
18    }
19
20    return(local.queryArray);
21}

This entry was posted on June 30, 2011 at 11:25 AM and has received 159 views. There are currently 0 comments. Print this entry.