Displays output that can contain the results of processing CFML variables and functions. You can use the query attribute to loop over the result set of a database query.



Attribute Reference

query query

Name of cfquery from which to draw data for output section.

group string

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."

groupcasesensitive boolean

Whether to consider the case in grouping rows.
  • true
  • false

startrow numeric

Row from which to start output. Only considered when the query attribute is set.
This attribute in combination with maxrows can be used to create some paging.

maxrows numeric

Maximum number of rows to display. Only considered when the query attribute is set.

encodefor string

CF 2016+ Lucee 5.1+ When set applies an encoder to all variables to prevent XSS. For example if you specify html each variable will be wrapped by a call to the encodeForHTML function.
  • html
  • htmlattribute
  • javascript
  • css
  • xml
  • xmlattribute
  • url
  • xpath
  • ldap
  • dn

Sample code using the cfoutput tag

<cfoutput>Some text and a #encodeForHTML(variable)#</cfoutput>

Loops over each row of the query specified and outputs the result.

<cfoutput query="news">

Loops over 10 rows of the query specified starting from row 5 and outputs the result.

<cfoutput query="news" startrow="5" maxrows="10">

CF 2016+ Lucee 5.1+ By specifying encodefor="html" each variable is encoded using the encodeForHTML function before it is output.

<cfoutput query="news" encodefor="html">

Creates a dummy query food, with columns name and type. Then outputs the food by grouping by the type.

<cfset food = queryNew("name,type",
    [ {name:"Apple",type:"Fruit"}, 
      {name:"Chicken",type:"Meat"} ])>
<cfoutput query="food" group="type">

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub