Skip to content

Instantly share code, notes, and snippets.

@stevewithington
Last active March 2, 2024 23:25
Show Gist options
  • Save stevewithington/630b1fc5611b391da420 to your computer and use it in GitHub Desktop.
Save stevewithington/630b1fc5611b391da420 to your computer and use it in GitHub Desktop.
Convert a ColdFusion/CFML Query to an Array
<cfscript>
public array function queryToArray(query data) {
var local = {};
local.Columns = ListToArray(arguments.Data.ColumnList);
local.QueryArray = ArrayNew(1);
for (local.RowIndex=1; local.RowIndex <= arguments.Data.RecordCount; local.RowIndex++) {
local.Row = {};
for (local.ColumnIndex=1; local.ColumnIndex <= ArrayLen(local.Columns); local.ColumnIndex++) {
local.ColumnName = local.Columns[local.ColumnIndex];
local.Row[local.ColumnName] = arguments.Data[local.ColumnName][local.RowIndex];
}
ArrayAppend(local.QueryArray, local.Row);
}
return local.QueryArray;
}
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment