I’ve recently come across an interesting and informative article on protecting your Coldfusion-powered site from SQL-Injection.
Ryan Wagener has posted on the Adobe Developer Center, a novice-guide to what SQL Injection and Attacks are, how they could manifest on your website, and how to protect
Hackers would take advantage of your code by modifying variables sent via HTTP Get (such as http://blah.com?table=name) or Post (form submissions) to assign specific malicious alterations to the normal sql code, thus exposing your database and table structure. The article touches on various suggestions to help protect your website, from creating error template pages to naming of tables. You can find the article at http://www.adobe.com/devnet/coldfusion/articles/sql_injection_print.html .