<!--- set the default column to sort by. here ours is called Lname ---><cfparam name = "session.lastCol" default = "Lname">
<cfscript>
function changeOrder(colName){ /*If this is the first time the page is loaded we have to be sure to change the default column to "DESC". Otherwise the first time a user clicks the link to sort it the other direction nothing will happen.*/ if(not isdefined("url.sortCol")){ /*If the default column name and the name passed to the function are the same set the next sort order to "DESC"*/ if(session.lastCol eq colName){
newOrder = "DESC";
}else{
newOrder = "ASC";
} /*return the query string that will sort the query. In this example the return may look like sortCol=Lname&sortOrder=DESC*/ return "sortCol=" & colName & "&sortOrder=" & newOrder;
}else{ /*Check to see if the user is clicking on the same column to change the sort order.*/ if((session.lastCol eq url.sortCol) AND (colName eq url.sortCol)){ /*change the sort order in the link*/ if(url.sortOrder eq "ASC"){
newOrder = "DESC";
}else{
newOrder = "ASC";
}
return "sortCol=" & colName & "&sortOrder=" & newOrder;
}else{ /*if the user clicked a different heading to sort by we must change the last sort column held in the session variable and change the next sort order to DESC if the column is not a clicked column the sort order will go back to ASC*/ if(colName eq url.sortCol){
session.lastCol = colName;
newOrder = "DESC";
}else{
newOrder = "ASC";
}
return "sortCol=" & colName & "&sortOrder=" & newOrder;
}
}
}
</cfscript><!--- Sample query---><cfquery>
SELECT Lname, title, empNumber
FROM myTable
ORDER BY <!--- if this is the first time the page loads it will sort on the column you set as the default in ASC order. If the url variable exists it will sort by them instead. ---> <cfif isdefined("url.sortCol")>
#url.sortCol# #url.sortOrder#
<cfelse>
#session.lastCol# ASC
</cfif>
</cfquery> Here we have 3 columns, Lname, positionTitle, and EmpNumber but you can have any number of columns with any valid name.
<cfoutput>
<tr>
<td><a href = "yourpage.cfm?
#changeOrder('Lname')#">Name</a></td>
<td><a href = "yourpage.cfm?
#changeOrder('positionTitle')#">Title</a></td>
<td><a href = "yourpage.cfm?
#changeOrder('EmpNumber')#">Employee Number</a></td>
</tr>
</cfoutput>
Talk To Other Members
