Randy,
I had done this same code just this morning as a workaround to get by. - Thx
for validating my decision...
All,
As in the case of most of us here.
I am not a person that likes "workarounds" when there is a bug, so while I
have "working" code, it still does not answer what is really bro
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
Hey Everyone,
I moved back to Minneapolis over the last week or
so. While no longer a resident of Kansas City, I still intend to lurk here
an occasionally post whatever insight I can.
--Daryl Banttari
Sr. Product Support Engineer
Macromedia
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
I am having terrible luck trying to resolve an issue that came up this
weekend.
It appears that using certain expressions within CFMX are not properly
escaping quotes in strings.
Objective= Find possible dupe records before inserting a record from Table1
into Table2
Sample Data In Database #1 an
Upcoming meetings, book reviews, free software - read our first
newsletter at www.kcfusion.org!
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf
