Contents

cfoutput

Description

Displays the results of a database query or other operation. To nest cfoutput tags, see the "Usage" section.

Category

Other

Implemented

Usage Syntax

<cfoutput  
	[query="String"]
	[group="String"]
	[groupCaseSensitive="Boolean"]
	[startRow="number"]
	[maxRows="number"]
 />

[] = Optional attribute

Attributes

Name Type Required Default Description
query String No The name of the cfquery from which to draw data for the output section.
group String No 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 a record set is ordered according to "CustomerID" in the cfquery tag, you can group the output on "CustomerID." The group attribute, which is case sensitive, eliminates adjacent duplicates when the data is sorted by the specified field. See the groupCaseSensitive attribute for information about specifying a case i nsensitive grouping.
groupCaseSensitive Boolean No Boolean indicating whether to group by case. 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 number No Specifies the row from which to start output.
maxRows number No Specifies the maximum number of rows to display in the output section.

Example Usage