Advertisement
tommyready

Untitled

Jul 22nd, 2016
288
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <cfset myQuery = QueryNew("Name, Time, Advanced", "VarChar, Time, Bit")>
  2.  
  3. <cfset QueryAddRow(MyQuery, 2)>
  4.  
  5. <cfset QuerySetCell(myQuery, "Name", "Test 1", 1)>
  6. <cfset QuerySetCell(myQuery, "Time", "9:15 AM", 1)>
  7. <cfset QuerySetCell(myQuery, "Advanced", False, 1)>
  8. <cfset QuerySetCell(myQuery, "Name", "Test 2", 2)>
  9. <cfset QuerySetCell(myQuery, "Time", "12:15 PM", 2)>
  10. <cfset QuerySetCell(myQuery, "Advanced", True, 2)>
  11. <cfscript>
  12.     public void function doLoop(queryObj) {
  13.         for( dRow in arguments.queryObj ) {
  14.             writeOutPut( queryObj.currentRow );
  15.             writeOutPut( '<br />' );
  16.         }        
  17.     }
  18.     doLoop( MyQuery );
  19. </cfscript>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement