tracker issue : CF-4204281

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

cfoutput groupcasesensitive defaulting to No after update 10

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Susan P. / ()

Created: 05/01/2019

Components: Documentation, Documentation, Examples, Language, Tags

Versions: 2016

Failure Type: Incorrect w/Workaround

Found In Build/Fixed In Build: 2016,0,10,314028 / docs

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Win 2008 Server R2

Vote Count: 0

Problem Description: outputting a query with a group results in case-insensitive grouping when the default behavior is case-sensitive

Steps to Reproduce:
<cfscript>
colors = queryNew("id,color",
    "integer,varchar",
    [ {"id":1,"color":"RED"}, {"id":2,"color":"Red"} , {"id":3,"color":"red"} ]);
</cfscript>
Default:<br>
<cfoutput query="colors" group="color">
	#color#<br>
</cfoutput>
Explicit:<br>
<cfoutput query="colors" group="color" groupcasesensitive="yes">
	#color#<br>
</cfoutput>

Actual Result:
RED
Expected Result:
 RED
 Red
 red
Any Workarounds:
explicitly add groupcasesensitive="yes" to every query output with a group and possible case issues

Attachments:

Comments:

Hi Susan, The default value is "false" for groupcasesensitive attribute and we will update the documentation. Thanks for pointing it out.   -Mukesh
Comment by Mukesh K.
30709 | May 10, 2019 07:39:35 AM GMT