CF Upgrade Gotcha (6.1 to 7.0.2)

With the CFMX 6.1 reaching its end of life my company is in the process of upgrading ColdFusion. Unfortunately Adobe chose to EOL CF 6.1 before CF 8 was released, so my company began the upgrade process to 7.0.2. (I'm going to do my best to convince the powers that be to upgrade to 8, but that may be difficult given that it is brand spankin' new.)

Anyway, we have been running 7.0.2 on our local development boxes for the past month or so and we have only really hit one issue; that issue has to do with the QuerySetCell function. In ColdFusion 7 and 8 the QuerySetCell function does type validation. What does this mean? Well CF 6 wouldn't complain if you tried to set a numeric column to a text value like so:


BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.