After Coldfusion 2016 update 10 I have had to add groupcasesensitive="yes" to cfoutputs that were ok before

Forum|Forum|6 years ago
May 1, 2019
2 replies
263 views

Has anyone else seen this? groupcasesensitive is optional, and the default is "yes", so I was surprised when a user reported the tally by country indicated 40 items found but the country breakdown only summed to 36. Turns out we had 13 for Nigeria and 4 for NIGERIA. The report was displaying NIGERIA 13, first label, last value, which I find baffling.

After explicitly adding groupcasesensitive="yes" to that query, everything is as expected- both rows display and the running sub-count now totals to 40.

We are standard license on windows. I'll see if I can replicate in a simple demo and share.

This topic has been closed for replies.

WolfShade

Legend

That's an odd little quirk. I'd report it as a bug to Adobe. https://tracker.adobe.com

V/r,

^ _ ^

B

Bewitched_strategist1549Author

Participating Frequently

<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>
gave me the following on both my dev and production servers
Default: RED Explicit: RED Red red