Case-Insensitive Output Grouping

The GROUP attribute allows you to group records together within an output loop. By default, group processing is case-sensitive – meaning that values in the GROUP column that differ by case are treated as being in different groups. Obviously this has no impact on numeric values, but this does affect text values – especially as most SQL operations are case-insensitive. Therefore, when grouping by text fields be sure to specify GROUPCASESENSITIVE=”no” if your SELECT statement is case-insensitive itself. (Applies to: ColdFusion All)

Leave a Reply