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

Day 10. Enhancing Output with Tables and... > Creating Output Using the GROUP Para...

Creating Output Using the GROUP Parameter

To create pages like Figure 10.7, you use an ORDER BY clause in your <CFQUERY> in conjunction with the GROUP parameter in your <CFOUTPUT> statement. Recall that ORDER BY causes the results of your query to be returned in a certain order, arranging records alphabetically or numerically by the field you specify.

Note

ColdFusion's GROUP output parameter only works properly if you've supplied an ORDER BY statement in your SQL query. In order for <CFOUTPUT> to accurately group a set of records, it must receive the records pre-ordered by the "grouped" field.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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