Skip to content

Instantly share code, notes, and snippets.

/trycf-gist.cfm

Created January 23, 2018 23:09
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/258a56456c29bae7dfe5564376f1f0ef to your computer and use it in GitHub Desktop.
Save anonymous/258a56456c29bae7dfe5564376f1f0ef to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist.cfm
<cfscript>
/* Create an unsorted CF-query */
unsorted = QueryNew("col1,col2,col3,col4","VarChar,VarChar,Integer,VarChar");
for ( a=10; a >= 1; a-- ) {
QueryAddRow(unsorted);
QuerySetCell(unsorted,"col1","col1 #a#");
QuerySetCell(unsorted,"col2","col2 #a#");
QuerySetCell(unsorted,"col3","#a#");
QuerySetCell(unsorted,"col4","col4 #a#");
}
writeDump(var="#unsorted#");
sorted = queryExecute(
"select [col1],[col2] from unsorted order by [col3], [col4] asc", {}, { dbtype="query" }
);
writeDump(var="#sorted#", label="sorted");
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment