ColdFusion is very good about providing descriptive error messages. Unfortunately, SQL and ODBC are not. But here’s a useful tip – if you ever receive really odd database errors (missing attributes, too many parameters, column does not exist, things like that) the first thing you should do is check your typing. More often than not, these are caused by mistyped column names, missing commas, and mismatched quotes or parentheses. (Applies to: ColdFusion All)

Leave a Reply