Tuesday, 21 August 2012

Error Executing Database Query

[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.

I received this vague error after I had added some extra columns into a table.

The code:

It turns out the error was being caused by the SELECT * as the ColdFusion server must have been caching the query. Restarting ColdFusion server fixed this, but to avoid receiving this error in the future only the columns that are required in the query should be listed.

No comments:

Post a Comment