434
Chapter 20: Accessing and Retrieving Data
<cfoutput>
The query returned #EmpList.RecordCount# records.
</cfoutput>
</body>
</html>
2
Save the file and view it in your web browser:
The number of employees now appears below the list of employees. You might have to refresh
your browser and scroll to see the RecordCount output.
Note:
The variable
cfquery.executionTime
contains the amount of time, in milliseconds, it took for
the query to complete. Do not prefix the variable name with the query name.
Reviewing the code
You now display the number of records retrieved in the query. The following table describes the
code and its function:
Query variable notes and considerations
When using query variables, keep the following guidelines in mind:
•
Reference the query variable within a
cfoutput
block so that ColdFusion outputs the query
variable value to the page.
•
Surround the query variable reference with pound signs (#) so that ColdFusion knows to
replace the variable name with its current value.
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.
Summary of Contents for ColdFusion MX
Page 1: ...Developing ColdFusion MX Applications...
Page 22: ...22 Contents...
Page 38: ......
Page 52: ...52 Chapter 2 Elements of CFML...
Page 162: ......
Page 218: ...218 Chapter 10 Writing and Calling User Defined Functions...
Page 250: ...250 Chapter 11 Building and Using ColdFusion Components...
Page 264: ...264 Chapter 12 Building Custom CFXAPI Tags...
Page 266: ......
Page 314: ...314 Chapter 14 Handling Errors...
Page 344: ...344 Chapter 15 Using Persistent Data and Locking...
Page 349: ...About user security 349...
Page 357: ...Security scenarios 357...
Page 370: ...370 Chapter 16 Securing Applications...
Page 388: ...388 Chapter 17 Developing Globalized Applications...
Page 408: ...408 Chapter 18 Debugging and Troubleshooting Applications...
Page 410: ......
Page 426: ...426 Chapter 19 Introduction to Databases and SQL...
Page 476: ...476 Chapter 22 Using Query of Queries...
Page 534: ...534 Chapter 24 Building a Search Interface...
Page 556: ...556 Chapter 25 Using Verity Search Expressions...
Page 558: ......
Page 582: ...582 Chapter 26 Retrieving and Formatting Data...
Page 668: ......
Page 734: ...734 Chapter 32 Using Web Services...
Page 760: ...760 Chapter 33 Integrating J2EE and Java Elements in CFML Applications...
Page 786: ...786 Chapter 34 Integrating COM and CORBA Objects in CFML Applications...
Page 788: ......