Re: Sorting and Stored Procedure

["JR "Bob" Dobbs" <webforumsuser@xxxxxxxxxxxxxx>]

See attached sample using query of queries to sort.

 <!--- stored procedure will return resultset with 3 fields: FieldA, FieldB, 
FieldC.  Here we specify which to sort by --->
 <cfset variables.sortBy="FieldA" />


 <!--- get results for stored proc to variables.results --->
 <cfstoredproc procedure="spGetData" dataSource="myDataSource">
        <cfprocresult name="variables.results" /> 
 </cfstoredproc>

 <!--- use query or queries to sort --->
 <cfquery name="variables.reportData" dbtype="query">
        SELECT FieldA, FieldB, FieldC
        FROM variables.results 
        ORDER BY #variables.sortBy#
 </cfquery>


 <cfoutput query="variables.reportData">
        #FieldA#, #FieldB#, #FieldC#<br />
 </cfoutput>