Skip to content

Instantly share code, notes, and snippets.

/trycf-gist.cfm

Created December 27, 2017 05:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/6309cd1d0c94c5941c0bfcf322fb7df5 to your computer and use it in GitHub Desktop.
Save anonymous/6309cd1d0c94c5941c0bfcf322fb7df5 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist.cfm
<cfscript>
/* Create an unsorted CF-query */
queryMilestonesByDate = QueryNew("col1,col2,col3,col4","VarChar,VarChar,Integer,VarChar");
for (a=2;a gte 1;a--){
QueryAddRow(queryMilestonesByDate);
QuerySetCell(queryMilestonesByDate,"col1","col1 #a#");
QuerySetCell(queryMilestonesByDate,"col2","col2 #a#");
QuerySetCell(queryMilestonesByDate,"col3","#a#");
QuerySetCell(queryMilestonesByDate,"col4","col4 #a#");
}
writeDump(var=queryMilestonesByDate);
for (row in queryMilestonesByDate) {
writedump(row);
writedump(queryMilestonesByDate.col1);
}
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment