ColdFusion MX Double Quote Hotfix Part II
Back in December 2004 I blogged about a ColdFusion MX Double Quote Hotfix to solve a problem we were seeing on our CFMX6.1 server. The hotfix fixed the issue where the JDBC drivers would translate a single apostrophe to a double apostrophe when passed using cfqueryparam. It wasn't spotted for a while I'm sure because <soapbox>90% of developers I have met don't use CFQUERYPARAM religiously. </soapbox>
I was delighted that the bug was fixed but
dismayed to discover that a client we just moved to CF7 was
experiencing the issue again and despite applying the latest patches
and hotfixes, the JDBC drivers appear to be doing the same thing for
CFPROCPARAM. If anyone has any tips, I'm all ears. I was going to
spoof that last line with extra apostrophes but I didn't want someone
to miss the joke and point it out....