If it was MSSQL, you would want single quotes, so more like this:
SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0
AND categoryname IN ('aaaa''s') ORDER BY viewname ASC LIMIT 0, 300
Instead of setting your "havingClause" variable and messing with
preserveSingleQuotes(), can you just do this?
<cfquery>
SELECT viewname, categoryname
FROM views LEFT OUTER JOIN
viewcategories ON views.categoryid = viewcategories.categoryid
GROUP BY viewname
HAVING 0 = 0
AND categoryname IN ( <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#arrayToList(value)#" list="Yes" /> )
ORDER BY viewname ASC LIMIT 0, 300
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:337154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
