> right place. CF has no way to automatically know which one
> you're trying
> to do.
Well, it shouldn't try to be so clever <pout> :-) If there are ''s in my
string, I want them there, grrr.
> Use the PreserveSingleQuotes() function to prevent this behavior.
Works a charm, but I can't seem to use that in the cfquery tag, so I have to
say
--
<cfset where =MakeWhereClause(CreateRecordID( qQuery))>
<cfquery ...
select * from actuals where #PreserveSingleQuotes(where)#
...
--
Which isn't as elegent as
#PreserveSingleQuotes(MakeWhereClause(CreateRecordID( qQuery)))#
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
