Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfdump var="#serializeJSON(findglobal)#">
- {
- "COLUMNS": [
- "DELIVERED_PERCENTAGE",
- "UNIQUE_PERCENTAGE",
- "SPAM_PERCENTAGE",
- "DROP_PERCENTAGE",
- "REQUEST_PERCENTAGE",
- "BOUNCE_PERCENTAGE",
- "DEFERRED_PERCENTAGE",
- "PROCESSED_PERCENTAGE",
- "OPEN_PERCENTAGE",
- "BLOCKED_PERCENTAGE"
- ],
- "DATA": [
- [
- 19.54,
- 6.06,
- 6.05,
- 0.63,
- 21.17,
- 0.85,
- 14.83,
- 20.53,
- 10.26,
- 0.19
- ]
- ]
- }
- {
- "item": [
- {
- "value": "11234",
- "label": "Webmail",
- "colour": "FFFF10AA"
- },
- {
- "value": "10736",
- "label": "Phone",
- "colour": "FFAA0AAA"
- },
- {
- "value": "230",
- "label": "Webmail",
- "colour": "FF5505AA"
- },
- {
- "value": "280",
- "label": "Webmail",
- "colour": "FF0000AA"
- }
- ]
- }
- public array function queryToArray( required query qry ) {
- var columns = arguments.qry.getColumnNames();
- var OutputResult = [];
- for( var i = 1; i LTE qry.recordCount; i++ ) {
- var obj = {};
- for( var k = 1; k LTE arrayLen( columns ); k++ ) {
- structInsert( obj, columns[ k ], arguments.qry[ columns[ k ] ][ i ] );
- }
- arrayAppend(OutputResult, obj );
- }
- return OutputResult;
- }
- <cfset myJSON = queryToArray( myquery ) />
- <cfoutput>#serializeJSON( myJSON )#</cfoutput>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement