thanks for the replies, although the preserveSingleQuotes doesnt work
> hi, we are running a cfquery with the following sql statement:
>
> SELECT viewname, categoryname FROM views LEFT OUTER JOIN
> viewcategories on views.categoryid = viewcategories.categoryid GROUP
> BY viewname HAVING categoryname IN ("aaaa's") ORDER BY viewname ASC
> LIMIT 0, 300
>
> if we type this directly into mysql it works fine, similarly if we
> type it directly into a <cfquery> it works fine. however the having
> clause is getting built from following code and is causing the
> problem:
>
> <cfset value = arraynew(1) />
> <cfset value[1] = "aaaa's" />
> <cfloop index="a" from="1" to="#arraylen(value)#">
> <cfset value[a] = '"#value[a]#"' />
> </cfloop>
> <cfset havingClause = "HAVING categoryname IN (#arraytolist(value)#)"
> />
>
> the problem is occuring due to the apostrophe '. we have tried
> preserveSingleQuotes but still does not work.
>
> is there any way around this?
>
> thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:337119
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
