Search code examples
sqlcoldfusioncoldfusion-8

How do I group my cfquery on multiple columns?

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?

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>