Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1559248037180-dc87bbb1-3dbf-0e5c-1e11-591b90c53543.cfm

Created May 30, 2019 20:32
Show Gist options
  • Save trycf/5181e9c6168b1aecdf47ba260ac3718e to your computer and use it in GitHub Desktop.
Save trycf/5181e9c6168b1aecdf47ba260ac3718e to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1559248037180-dc87bbb1-3dbf-0e5c-1e11-591b90c53543.cfm
<cfscript>
qry = queryNew("REC_ID,NAME,STATUS,TYPE,YEAR"
, "varchar,varchar,varchar,integer,integer"
, [ {REC_ID="01",Name="PARIS", Status="Approved", Type=1, Year=2019}
, {REC_ID="06",Name="AUSTIN", Status="Inactive", Type=3, Year=2017}
]);
writeDump( formatData( qry ));
array function formatData(qryData) {
return DeserializeJSON(SerializeJSON(arguments.qryData, "struct"));
}
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment