Tips for Debugging Applications and Queries
If your application has no syntax errors but it is not producing the correct result, the following output information may be helpful:
- Variables - CGI environment variables, form fields, and URL parameters passed with client request.
- Processing Time - Time in milliseconds it takes the ColdFusion application server to process a page request.
- SQLand data source name - The SQL statement and data source name in use when the error occurred.
- Query information - Processing time, number of records, and SQL statement for each query executed.
Viewing Debug Information for an Application Page
To view debug information for an individual application page, append the parameter mode=debug to end of URL.
wnt.cc.utexas.edu/cfscripts/test/filename.cfm?mode=debug
Note: Debugging is disabled on the ITS ColdFusion Server for security reasons, but will be useful in a development environment.
Viewing Debug Information for a Query
To view debug information for an individual query, add the DEBUG attribute to the opening CFQUERY tag.
<CFQUERY NAME = "TESTQUERY" DATASOURCE = "MINE" DEBUG>
SELECT *FROM MYTABLE
</CFQUERY>
