CFLib.org – Common Function Library Project

Description:
Sorts a query using Query of Query.

Return Values:
Returns a query.

Example:

<cfquery name="getit" datasource="cflib" maxrows=4>
    select name,id from tblUDFs
    order by id desc
</cfquery>
<cfdump var="#getIt#" label="Before Sort">
<cfdump var="#querySort(getit,"name")#" label="After Sort">

Parameters:

Full UDF Source:

<!---
 Sorts a query using Query of Query.
 Updated for CFMX var syntax.
 
 @param query      The query to sort. (Required)
 @param column      The column to sort on. (Required)
 @param sortDir       The direction of the sort. Default is "ASC." (Optional)
 @return Returns a query. 
 @author Raymond Camden (ray@camdenfamily.com) 
 @version 2, October 15, 2002 
--->
<cffunction name="QuerySort" output="no" returnType="query">
    <cfargument name="query" type="query" required="true">
    <cfargument name="column" type="string" required="true">
    <cfargument name="sortDir" type="string" required="false" default="asc">

    <cfset var newQuery = "">
    
    <cfquery name="newQuery" dbType="query">
        select * from query
        order by #column# #sortDir#
    </cfquery>
    
    <cfreturn newQuery>
    
</cffunction>