To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] CFMX Possible Bug HELP!
If PreserveSingleQuotes doesn't work, you may try replacing single quotes
within the variable with two singles quotes.
Example:
SELECT ID
FROM TABLE2
WHERE NAME LIKE '%#Replace(left(table1query.name,5),"
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 -
From
If PreserveSingleQuotes doesn't work, you may try replacing single quotes
within the variable with two singles quotes.
Example:
SELECT ID
FROM TABLE2
WHERE NAME LIKE '%#Replace(left(table1query.name,5),"'","''","ALL")#%'
This should fix the example you provided.
I'm not sure what would happen i
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, 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 i
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 http://www.ma