Skip to content

Instantly share code, notes, and snippets.

@smrchy
Created September 16, 2011 19:55
Show Gist options
  • Save smrchy/1222976 to your computer and use it in GitHub Desktop.
Save smrchy/1222976 to your computer and use it in GitHub Desktop.
queryToObject
<!--- suppose your query you did with cfquery is stored in the variable myQuery --->
<script>
var q = #SerialzeJSON(myQuery,true)#;
// make an easy to use object
var newQuery = queryToObject(q);
console.log(newQuery);
</script>
# ## queryToObject
# This function expects a Coldfusion query object generated with `SerializeJSON(query,true)`
# and transforms it into a Javascript object like this:
#
# [
# {id: 1, name: "Germany"},
# {id: 2, name: "Denmark"}
# ]
#
queryToObject = (q) ->
for i in [0...q.ROWCOUNT]
r = {}
for col in q.COLUMNS
r[col.toLowerCase()] = q.DATA[col][i]
r
// Javascript version
var queryToObject;
queryToObject = function(q) {
var col, i, r, _i, _len, _ref, _ref2, _results;
_results = [];
for (i = 0, _ref = q.ROWCOUNT; 0 <= _ref ? i < _ref : i > _ref; 0 <= _ref ? i++ : i--) {
r = {};
_ref2 = q.COLUMNS;
for (_i = 0, _len = _ref2.length; _i < _len; _i++) {
col = _ref2[_i];
r[col.toLowerCase()] = q.DATA[col][i];
}
_results.push(r);
}
return _results;
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment