problem in case insensitive cfgridcolumn sorting in cf8

[Vignesh_Jayaprakash]

Hi,

I am working on cfgrid in coldfusion 8. In that i need to sort the columns case insensitive .

ie, I want the replica of the "type =string_noCase"  in  cfgridcolumn of coldfusion 9.

please help me to sort out this issue..............

--vignesh

[brambilaa]

You may want to consider doing this on the database side.  You could add a column called Sort, copy the data as upper

case, and sort on that column instead.  Just an idea.

Good luck

[Vignesh_Jayaprakash]

Thanks for your response..................

But my requirement is case insensitive sorting in cfgrid in cf8.....

database side should not be touched......

[Adam Cameron.]

It's a bug - http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=82079 - to fix, you need to upgrade (*).  I guess you could horse around overriding the sort mechanism on <cfgrid>, but that just sounds like a nightmare to me.

--

Adam

(*) that said, all I can glean from the bugtracker is that it's closed.  This in no way indicates that it's fixed.  So before upgrading anything to mission critical, I'd get a CF9 box stummed up and test.

[Vignesh_Jayaprakash]

i didnt get u

[Adam Cameron.]

What you are experiencing is a bug in CF8.  One CANNOT do a case-insensitive column sort with <cfgrid> in CF8. If you want to do this, you need to upgrade to CF9.

--

Adam

[Vignesh_Jayaprakash]

Thanks for your response adam.......

Is there any other way to sort out this issue in cf8?