Webmaster Forum / ColdFusion / Advanced Techniques / February 2005

Hi,

I would like to know if I can use cfgridcolumn to sort by a field other than
what I want to display. For example, this is my query:
<cfquery name="myQuery"....>
select rank, description
from myTable
</cfquery>

So I want to display the "description" but when I click the header of this
column I want to sort by "rank". Right now it will sort by description. I do
not want to display "rank" because it has no meaning to the user.

<cfgrid query="myQuery" name="mechGrid" rowheaders="no" height="800"
sort="yes">
     <cfgridcolumn name="description" display="true" >    <!---but I want to sort
by "rank" here--->       
</cfgrid>