Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. <cfdump var="#serializeJSON(findglobal)#">
  2.  
  3. {
  4. "COLUMNS": [
  5. "DELIVERED_PERCENTAGE",
  6. "UNIQUE_PERCENTAGE",
  7. "SPAM_PERCENTAGE",
  8. "DROP_PERCENTAGE",
  9. "REQUEST_PERCENTAGE",
  10. "BOUNCE_PERCENTAGE",
  11. "DEFERRED_PERCENTAGE",
  12. "PROCESSED_PERCENTAGE",
  13. "OPEN_PERCENTAGE",
  14. "BLOCKED_PERCENTAGE"
  15. ],
  16. "DATA": [
  17. [
  18. 19.54,
  19. 6.06,
  20. 6.05,
  21. 0.63,
  22. 21.17,
  23. 0.85,
  24. 14.83,
  25. 20.53,
  26. 10.26,
  27. 0.19
  28. ]
  29. ]
  30. }
  31.  
  32. {
  33. "item": [
  34. {
  35. "value": "11234",
  36. "label": "Webmail",
  37. "colour": "FFFF10AA"
  38. },
  39. {
  40. "value": "10736",
  41. "label": "Phone",
  42. "colour": "FFAA0AAA"
  43. },
  44. {
  45. "value": "230",
  46. "label": "Webmail",
  47. "colour": "FF5505AA"
  48. },
  49. {
  50. "value": "280",
  51. "label": "Webmail",
  52. "colour": "FF0000AA"
  53. }
  54. ]
  55. }
  56.  
  57. public array function queryToArray( required query qry ) {
  58. var columns = arguments.qry.getColumnNames();
  59. var OutputResult = [];
  60.  
  61. for( var i = 1; i LTE qry.recordCount; i++ ) {
  62. var obj = {};
  63.  
  64. for( var k = 1; k LTE arrayLen( columns ); k++ ) {
  65. structInsert( obj, columns[ k ], arguments.qry[ columns[ k ] ][ i ] );
  66. }
  67.  
  68. arrayAppend(OutputResult, obj );
  69. }
  70.  
  71. return OutputResult;
  72. }
  73.  
  74. <cfset myJSON = queryToArray( myquery ) />
  75. <cfoutput>#serializeJSON( myJSON )#</cfoutput>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement