O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required