This function sorts a query where the sorting algorithm is passed at runtime in the form of closure.
boolean QuerySort(Object query , UDFMethod sortFunc)
| Parameter | Description |
| query | (Required) The query to be sorted. |
| sortFunc | (Required) Sort function to be used. |
<cfscript>
qoptions = {result="myresult", datasource="cfbookclub", fetchclientinfo="yes"};
sampleQuery = QueryExecute("select * from books order by bookid", [] ,qoptions);
sortStatus = QuerySort(sampleQuery, function(e1, e2){
return compare(e1.TITLE, e2.TITLE);
});
writeOutput("Sort Successful: " & sortStatus);
writeDump(sampleQuery);
</cfscript>
<cfscript>
myResult=QueryExecute("SELECT * FROM EMPLOYEES",[],{datasource="cfdocexamples"});
status=myResult.sort(function (c1,c2){
return compare(c1.DEPARTMENT,c2.DEPARTMENT);
});
WriteDump(myResult);
</cfscript>
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.