ColdFusioning.com
Pronunciation \kold-fy-zhn-ing\ Noun: The actions of one that writes ColdFusion.

Please check out my new site: http://ja.mesbrown.com/

DELETED

I recently made an update to a table and start receiving a weird error:

view plain print about
1[Macromedia][Oracle JDBC Driver][Oracle]ORA-01722: invalid number

even though the SQL hadn't changed and I had only added a column to the database. Well, it turns out that cfqueryparam and ColdFusion do some weird caching that was causing the error. If changed the query (i.e. change the order of the WHERE statements (which didn't change the results)), the error went away.

Truly a weird error.

TweetBacks

Comments

Recent Comments

RSS

Subscribe