I have absolutely no idea why this happened, but today i started to get errors in 2 scripts that previously was working fine.
First one started to return a java.lang.NullPointerException error on cfqueryparam cfsqltype="CF_SQL_INTEGER" and the second something like conversion failed error for same type of cfqueryparam cfsqltype="CF_SQL_INTEGER".
As soon as i removed the CFSQLPARAM's and used direct just variables there all started to work again.
Did anyone have similar issues in the past and if so what was the solution?
Posted At : Mar 25, 2010 22:49 PM
| Posted By : Ed Tabara
Related Categories: ColdFusion
Related Categories: ColdFusion
| 4233 Views
| 5% / 1% Popularity
using "SELECT *" is very bad indeed and it indeed may lead to weird results especially when DB structure is changed.