Advertisement
murp

Array of Structures ColdFusion Example

Apr 7th, 2014
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!--- Create the query --->
  2. <cfscript>
  3. myQuery=queryNew("fruit,color","Integer,Varchar",[ ["apples","green"], ["banannas","yellow"], ["grapes","purple"] ]);
  4.  
  5. function QueryToArrayOfStructures(theQuery){
  6. var theArray = arraynew(1);
  7. var cols = ListtoArray(theQuery.columnlist);
  8. var row = 1;
  9. var thisRow = "";
  10. var col = 1;
  11. for(row = 1; row LTE theQuery.recordcount; row = row + 1){
  12. thisRow = structnew();
  13. for(col = 1; col LTE arraylen(cols); col = col + 1){
  14. thisRow[cols[col]] = theQuery[cols[col]][row];
  15. }
  16. arrayAppend(theArray,duplicate(thisRow));
  17. }
  18. return(theArray);
  19. }
  20. result = queryToArrayOfStructures( myQuery );
  21. writedump( result );
  22. writedump( serializeJSON( result ) );
  23. </cfscript>
  24. <cfoutput>
  25. <script>
  26. var deets = JSON.parse( '#serializeJSON( result )#' );
  27. for( var i=0; i<deets.length; i++ ) {
  28. alert( deets[ i ].COLOR );
  29. }
  30. </script>
  31. </cfoutput>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement