On 9/16/2010 6:44 AM, Richard White wrote:
> thanks for the replies, although the preserveSingleQuotes doesnt work
You should be looking at the actual SQL that is being sent to the
database. It would be provide clear evidence of what is wrong.
Looking at this line:
<cfset havingClause = "HAVING categoryname IN (#arraytolist(value)#)"
I expect you are getting SQL output that looks like this:
HAVING categoryname IN (aaa'a)
What proper SQL should look like is:
HAVING categoryname IN ('aaa''a') <!--- note the double single quotes
inside the outer quotes --->
You may want to investigate the listQualify() function.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337120
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
