How do I group my cfquery on multiple columns?

coldfusion, coldfusion-8, sql

Solution

You add extra `<cfoutput group="">` tags.

<cfoutput query="myQry" group="date">
 <cfoutput group="category">
  <cfoutput group="description">
   #date# #category# #description#
   <cfoutput>
    #detail#
   </cfoutput>
  </cfoutput>
 </cfoutput>
</cfoutput>

Problem

I need to group my query where multiple columns match. For example, group all rows where date, category, and description match. I know how to use cfoutput grouping when grouping on one column, such as: ``` <cfoutput query="myQry" group="date"> #date# <cfoutput> #detail# </cfoutput> </cfoutput> ``` But, I want to group where multiple columns match, like so: ``` <cfoutput query="myQry" group="date,category,description"> #date# #category# #description# <cfoutput> #detail# </cfoutput> </cfoutput> ``` I know cfoutput grouping doesn't work like above. So how can I group on multiple columns?

Original source