MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Reference

Page: 173 / 608

Chapter 1: ColdFusion Tags 149
CFOUTPUT
Displays the results of a database query or other operation. If you need to nest
CFOUTPUT tags, please read the "Usage" section.
Syntax
<CFOUTPUT
QUERY="query_name"
GROUP="query_column"
GROUPCASESENSITIVE="yes/no"
STARTROW="start_row"
MAXROWS="max_rows_output">
</CFOUTPUT>
QUERY
Optional. The name of the CFQUERY from which you want to draw data for the
output section.
GROUP
Optional. Specifies the query column to use when you group sets of records
together. Use this attribute if you have retrieved a record set ordered on a certain
query column. For example, if you have a record set that is ordered according to
"Customer_ID" in the CFQUERY tag, you can group the output on "Customer_ID."
The GROUP attribute, which is case sensitive, eliminates adjacent duplicates in
the case where the data is sorted by the specified field. See the
GROUPCASESENSITIVE attribute for information about specifying a case
insensitive grouping.
GROUPCASESENSITIVE
Optional. Boolean indicating whether to group with regard to case or not. The
default value is YES; case is considered while grouping. If the QUERY attribute
specifies a query object that was generated by a case-insensitive SQL query, set the
GROUPCASESENSITIVE attribute to NO to keep the recordset intact.
STARTROW
Optional. Specifies the row from which to start output.
MAXROWS
Optional. Specifies the maximum number of rows you want displayed in the
output section.
Usage
In order to nest CFOUTPUT blocks, you must specify the GROUP and QUERY
attributes at the top-most level, and the GROUP attribute for all inner blocks except for
the inner-most CFOUTPUT block.