Skip to main content
V
Vignesh_Jayaprakash
Participating Frequently
January 26, 2011
Question

problem in case insensitive cfgridcolumn sorting in cf8

  • January 26, 2011
  • 2 replies
  • 644 views

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

    This topic has been closed for replies.

    2 replies

    A
    Adam Cameron.
    Inspiring
    January 27, 2011

    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.

    V
    Vignesh_JayaprakashAuthor
    Participating Frequently
    January 27, 2011

    i didnt get u

    A
    Adam Cameron.
    Inspiring
    January 27, 2011

    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

    A
    Anonymous
    January 26, 2011

    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

    V
    Vignesh_JayaprakashAuthor
    Participating Frequently
    January 27, 2011

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

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

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices