sorting cfgridcolumn by one field, display a differentfield

[Adila]

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>

[Mike Nimer]

no, the sort is sorting the data in the column, not going back to the query
so this isn't possible.

hth,
---nimer



"Adila" <webforumsuser@macromedia.com> wrote in message
news:cvvj2p$oqv$1@forums.macromedia.com...

> 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>
>