Adobe ColdFusion 8

Database Activity

In the Administrator, when Database Activity is selected on the Debugging Settings page, the debugging output includes information about database access.

SQL Queries

The SQL Queries section provides information about tags that generate SQL queries or result in retrieving a cached database query: cfquery, cfinsert, cfgridupdate, and cfupdate. The section looks like the following image in the dockable.cfm output format:

The output displays the following information:

  • Page on which the query is located.
  • The time when the query was made.
  • Query name.
  • An indicator if the result came from a cached query.
  • SQL statement, including the results of processing any dynamic elements such as CFML variables and cfqueryparam tags. This information is particularly useful because it shows the results of all ColdFusion processing of the SQL statement.
  • Data source name.
  • Number of records returned; 0 indicates no match to the query.
  • Query execution time.
  • Any query parameters values from cfqueryparam tags.

Stored Procedures

The stored procedures section displays information about the results of using the cfstoredproc tag to execute a stored procedure in a database management system.

The following image shows the Stored Procedures section in the classic.cfm output format:

The output displays the following information:

  • Stored procedure name
  • Data source name
  • Query execution time
  • Page on which the query is located.
  • The time when the query was made.
  • A table displaying the procedure parameters sent and received, as specified in the cfprocparam tags, including the ctype, CFSQLType, value variable, and dbVarName attributes. The variable information for OUT and INOUT parameters includes the returned value.
  • A table listing the procedure result sets returned, as specified in the cfprocresult tag.