A better debugging template for ColdFusion 6+
Today I saw a post regarding "re-assembling" a SQL string that had been separated into the SQL code and the bind variable values. This reminded me of the other nice change I made to my debug template. I was also a fan of copy-and-pasting queries from the CF debug window into my database front-end, and I created what I think is a pretty elegant solution to the loss of copy-and-paste-ability that comes with using CFQueryParam. The bind variables are inserted into the SQL string, but are colored blue to identify them as bind variables.
In the interest of improving the lives of CF developers everywhere, Singlebrook Technology is happy to share our wonderful doesntsuck.cfm debug template with you. Just download, unzip, and pop it in the "debug" folder inside your ColdFusion directory. Then you can select it as your debug template in the CF Administrator and I bet you'll never go back!
This template is compatible with ColdFusion 6.x, 7, and 8.