TryCF Gist

trycf-gist.cfm

<cfscript>
/* Create an unsorted CF-query */
unsorted = QueryNew("col1,col2,col3,col4","VarChar,VarChar,Integer,VarChar");
for (a=10;a gte 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#");

/* Create a new CF query of query with the unsorted table */ 
sorted = new query(
	dbtype = "query"
	,unsorted = unsorted
	,sql = "select [col1],[col2] from unsorted order by [col3], [col4] asc"
	).execute().getresult();
	
/* The last column in the order by list will be displayed in the result */	
writeDump(var="#sorted#", label="sorted");	
</cfscript>