Below is a very handy function to convert a query variable into a structure of structure. Enjoy.

view plain print about
1struct function queryToStruct(required query data, boolean unique=false)
2    output="false"
3{
4    var result = {};
5    var columns = listToArray(arguments.data.columnList);
6
7    for (var r=1;r<=arguments.data.recordCount;r++) {
8        var row = {};
9
10        for (var c=1;c<=arrayLen(columns);c++) {
11            var columnName = columns[c];
12            structInsert(row, columnName, arguments.data[columnName][r]);
13        }
14
15        structInsert(result, r, row);
16    }
17
18    if (structCount(result) == 1 && arguments.unique) {
19        result = result[structKeyArray(result)[1]];
20    }
21
22    return result;
23}

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