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.