Use CLIENT Variables Like SESSION Variables

No Spaces Around Equals Signs

Don't Overuse Lists

Never Use DB Admin Login

Never Assume a Variable Exists

Respect SQL Reserved Words

Get a List of Retrieved Columns

Use CFQUERYPARAM

Never Hard Code Custom Tag Return Variables

Use Stored Procedures