After you define a query on a page, you can use the cfoutput
tag with the query
attribute to output data from the record set to a page. When you use the query
attribute, keep the following in mind:
cfoutput
block, once for each row in the record set returned from the database.
cfoutput
block to output the data to the page.cfoutput
block to format the data on the page.cfoutput
tag, you can refer to the Firstname column in the Emplist query as Firstname. However, using the query name as a prefix-Emplist.Firstname- is preferred, and is in the following procedure.
The cfoutput
tag accepts a variety of optional attributes but, ordinarily, you use the query
attribute to define the name of an existing query.
<html> <head> <title>Employee List</title> </head> <body> <h1>Employee List</h1> <cfquery name="EmpList" datasource="CompanyInfo"> SELECT FirstName, LastName, Salary, Contract FROM Employee </cfquery> <cfoutput query="EmpList"> #EmpList.FirstName#, #EmpList.LastName#, #EmpList.Salary#, #EmpList.Contract#<br> </cfoutput> </body> </html>
A list of employees appears in the browser, with each line displaying one row of data.
Note: You might need to refresh your browser to see your changes.
You created a ColdFusion application page that retrieves and displays data from a database. At present, the output is raw and needs formatting. For more information, see "Retrieving and Formatting Data".
The results of the query appear on the page. The following table describes the highlighted code and its function:
When outputting query results, keep the following guidelines in mind:
cfquery
must precede the cfoutput
that references its results. Both must be on the same page (unless you use the cfinclude
tag; for more information, see "Including pages with the cfinclude tag," in Chapter 8).
query
attribute in the cfoutput
tag.cfoutput
block that uses a cfquery
attribute, you can prefix the query variables with the name of the query; for example, Emplist.FirstName
.query
attribute value with double quotes ("). <br>
tag to the end of the variable references so that ColdFusion starts a new line for each row that the query returns.