Each time you query a database with the cfquery tag, you get the data (the record set) and the query variables; together these comprise the query object. The following table describes the query variables, which are sometimes called query properties:
Variable |
Description |
---|---|
RecordCount |
The total number of records returned by the query. |
ColumnList |
A comma-delimited list of the query columns, in alphabetical order. |
SQL |
The SQL statement executed. |
Cached |
Whether the query was cached. |
SQLParameters |
Ordered array of cfqueryparam values. |
ExecutionTime |
Cumulative time required to process the query, in milliseconds. |
In your CFML code, you use these variables as if they were columns in a database table. Use the result attribute to specify the name of the structure that ColdFusion populates with these variables. You then use that structure name to refer to the query variables as the following example shows:
Output information about the query on your page
You now display the number of records retrieved in the query. The following table describes the code and its function:
Code |
Description |
---|---|
<cfoutput> |
Displays what follows. |
The query returned |
Displays the text "The query returned". |
#EmpList.RecordCount# |
Displays the number of records retrieved in the EmpList query. |
records. |
Displays the text "records." |
</cfoutput> |
Ends the cfoutput block. |
When using query variables, keep the following guidelines in mind: