Can't seem to get Query-of-Query to work with single quotes...
E.g.
WHERE name = 'Pvc's Office'
WHERE name = 'Pvc''s Office'
WHERE name = '#PreserveSingleQuotes("Pvc's Office")#'
WHERE name = <cfqueryparam value="Pvc's Office"
cfsqltype="CF_SQL_VARCHAR">
All don't work.
Is this a bug in QoQ, or can anybody think of another way around this???
Thanks,
Craig
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
