tracker issue : CF-3040934

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 82079:All my html cfgrids are sorting case sensitive

| View in Tracker

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: