So far, you have displayed data retrieved using database queries. But sometimes you’ll need access to data about queries (and not just data within queries). For example, if you wanted to display the number of movies retrieved, where would you get that count from?
To simplify this type of operation, ColdFusion can return special variables with every query using the optional RESULT structure. Table 10.1 lists these variables, and as you can see, RecordCount can provide the number of rows retrieved.
|Cached||Flag indicating whether or not returned query is a cached copy|
|ColumnList||Names of columns in query results (comma-delimited list)|
|ExecutionTime||Query execution time (in milliseconds) ...|