Doug,
I believe the 'preservesinglequotes' function in CF is intended to
handle quoting problems like this.
Ryan
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives
Actually, there was a slight change in behavior with CFMX. In CF5 (and
prior), automatic SQL string quoting would not happen if a function was used
against the data (in this case, the Left() function). In CFMX, the strings
are properly escaped, even if a function is used first.
So, you should
YepTried that as well.
That has not worked either.. It just does not seem that it is escaping
them correctly at some point in the MX or JDBC driver process.
Running the same code on CF5 does not have this problem.
Doug
Actually, this is the exact opposite problem I thought it was at first
glance.
It's not that single quotes are being quoted that shouldn't, the problem is
that single quotes are getting overlooked.
Let me try to replicate that and get back to the list.
--Daryl
- Original Message -