User Guide

cfoutput 323
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.
This tag requires an end tag.
Example
<!--- EXAMPLE: This example shows how cfoutput operates. --->
<!--- Run a sample query. --->
<cfquery name = "GetCourses" dataSource = "cfdocexamples">
SELECT Dept_ID, CorName, CorLevel
FROM courseList
ORDER by Dept_ID, CorLevel, CorName
</cfquery>
<h3>cfoutput Example</h3>
<p>cfoutput tells ColdFusion Server to begin processing, and then to hand back
control of page rendering to the web server.
<p>For example, to show today's date, you could write #DateFormat("#Now()#").
If you enclosed that expression in cfoutput, the result would
be<cfoutput>#DateFormat(Now())#</cfoutput>.
<p>In addition, cfoutput may be used to show the results of a query operation,
or only a partial result, as shown:
<p>There are <cfoutput>#getCourses.recordCount#</cfoutput> total records in
our query. Using the maxRows parameter, we are limiting our display to 4
rows.
<p><cfoutput query = "GetCourses" maxRows = 4>
#Dept_ID# #CorName# #CorLevel#<br>
</cfoutput>
<p>EXAMPLE: The next example uses the group attribute to eliminate duplicate
lines from a list of course levels taught in each department.</p>
<p><cfquery name = "GetCourses" dataSource = "cfdocexamples">
SELECT Dept_ID, CorLevel
FROM courseList
ORDER by Dept_ID, CorLevel
</cfquery>
<p><cfoutput query = "GetCourses" group="CorLevel" GroupCaseSensitive="True">
#Dept_ID# #CorLevel#<br>
</cfoutput>
<p>cfoutput can also show the results of a more complex expression,
such as getting the day of the week from today's date. We first
extract the integer representing the Day of the Week from
the server function Now() and then apply the result to
the DayofWeekAsString function:
<br>Today is #DayofWeekAsString(DayofWeek(Now()))#