Debugging SQL Statement or Logic Errors

Debugging SQL statements is one of the two types of troubleshooting you’ll spend most of your debugging time doing (the other is debugging ColdFusion syntax errors, which we’ll get to next). You will find yourself debugging SQL statements if you run into either of these situations:

  • ColdFusion reports SQL syntax errors. Figure 17.1, for example, is an error caused by misspelling a table name in a SQL statement. If you see only partial debug output, as shown in Figure 17.2, access the ColdFusion Administrator and turn on the Enable Robust Exception Information option in the Debugging Settings screen.

    Figure 17.1. ColdFusion displays SQL error messages as reported by the database driver.

Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.