Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Fred Valone / Fred Valone (frederickvalone)
Created: 02/14/2010
Components: AJAX, UI Components
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 / 270865
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 1
Problem:
All my html cfgrids are sorting case sensitive. I added the type="string_noCase" parameter but still am getting the same results with strings starting with uppercase chars displaying first and lower case strings displayed alphabetically after the uppercase strings. Thanks
Method:
create grid, and populate with string values starting with upper and lower case , add type=string_nocase to the column and try to sort.. Adam Cameron has been able to reproduce as well after my post to the forums friday
[vmannebo 2/15/2010]
Adding repro case:
<cfscript>
today = dateformat(now(),'mm/dd/yyyy');
emps = querynew("name,date");
queryaddrow(emps,5);
querysetcell(emps,"name","Zizou",1);
querysetcell(emps,"date",dateformat(dateadd('m',-3,today),'mm/dd/yyyy'),1);
querysetcell(emps,"name","Burruchaga",2);
querysetcell(emps,"date",today,2);
querysetcell(emps,"name","zizou",3);
querysetcell(emps,"date",dateformat(dateadd('m',12,today),'mm/dd/yyyy'),3);
querysetcell(emps,"name","zizou",4);
querysetcell(emps,"date",dateformat(dateadd('m',24,today),'mm/dd/yyyy'),4);
querysetcell(emps,"name","camille",5);
querysetcell(emps,"date",dateformat(dateadd('m',-24,today),'mm/dd/yyyy'),5);
writedump(emps);
</cfscript>
<br>
<div align="cennter">
<cfform>
<cfgrid name="g" format="html" query="emps" width="500" selectmode="edit" >
<cfgridcolumn name="name" >
<cfgridcolumn name="date" mask="d/m/y" width="150" type="date" >
</cfgrid>
</cfform>
<div>
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3040934
External Customer Info:
External Company:
External Customer Name: Fred Valone
External Customer Email: 3D06048E4460A870992016B6
External Test Config: 02/14/2010
Attachments:
Comments: