• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

4. Database Basics > 4.6. Grouping Output

Grouping Output

The cfoutput tag has an attribute called group that lets you to group output from your record sets before displaying it to the browser. There are two ways to use the group attribute of the cfoutput tag. The first method uses group to remove any duplicate rows from the query result set.[5] This is useful in situations where the result set you return from a query contains duplicate rows of data but you want to display only unique records.

Example 4-3 demonstrates what happens when you query a table containing duplicate values and output the results without using the group attribute of the cfoutput tag.

Example 4-3. Failing to use the group attribute results in duplicate values in the output
<cfquery name="GetDepartment" datasource="ProgrammingCF">
  SELECT Department
  FROM EmployeeDirectory
  ORDER BY Department
</cfquery>
   
<html>
<head>
  <title>Failing to Use the group Attribute Results in Duplicate Values in the 
         Output </title>
</head>
   
<body>
<h2>Departments:</h2>
   
<cfoutput query="GetDepartment">
#Department#<br>
</cfoutput>
   
</body>
</html>

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint