Guest User

Untitled

a guest
Jul 17th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. <cfscript>
  2. qry1=queryNew("a,b,c", "varchar,varchar,varchar", [["a1","b1","c1"], ["a2","b2","c2"], ["a3","b3","c3"]]);
  3. queryDeleteColumn(qry1,"c");
  4. writeOutput(qry1.columnlist);
  5.  
  6. qry2 = queryNew("x,y,z", "varchar,varchar,varchar", [["x1","y1","z1"], ["x2","y2","z2"], ["x3","y3","z3"]]);
  7. cfloop( query="qry2"){
  8. queryDeleteColumn(qry2,listFirst(qry2.columnlist));
  9. }
  10. writeDump(qry2.columnlist);
  11. </cfscript>
Add Comment
Please, Sign In to add comment