User Guide

cfoutput 263
cfoutput
Description
Displays output that can contain the results of processing ColdFusion variables and functions.
Can loop over the results of a database query.
Category
Data output tags
Syntax
<cfoutput
query = "query_name"
group = "query_column"
groupCaseSensitive = "Yes" or "No"
startRow = "start_row"
maxRows = "max_rows_output">
</cfoutput>
See also
cfcol, cfcontent, cfdirectory, cftable
Attributes
Usage
In the cfoutput tag body, ColdFusion treats text that is surrounded by pound signs (#) as a
ColdFusion variable or function call. For example, the following code displays the text "Hello
World!":
<cfset myVar="Hello World!">
cfoutput>#myVar#</cfoutput>
When you specify a query attribute, this tag loops over the query rows and produces output for
each row within the range specified by the
startRow and maxRows values, and groups or
eliminates duplicate entries as specified by the grouping attribute values, if any. It also sets the
query.currentRow variable to the current row being processed.
If you nest
cfoutput blocks that process a query, you specify the query and group attributes at
the top-most level; you can specify a group attribute for each inner block except the innermost
cfoutput block.
Attribute Req/Opt Default Description
query Optional Name of
cfquery from which to draw data for output section.
group Optional Query column to use to group sets of records. Eliminates
adjacent duplicate rows when data is sorted. Use if you
retrieved a record set ordered on one or more a query
columns. For example, if a record set is ordered on
"
Customer_ID" in the cfquery tag, you can group the output on
"
Customer_ID."
groupCase
Sensitive
Optional Yes Boolean. Whether to consider the case in grouping rows.
startRow Optional 1 Row from which to start output.
maxRows Optional displays all
rows
Maximum number of rows to display.