Hi all,

How do I keep CF from interpreting two single-quotes as escaped?  I'm storing 
code snippets into a database and all occurences of "''" are becoming "'" 
(e.g., "<cfset value = ''>" becomes "<cfset value = '>").

For example:

<cfset Var = "<cfset value = ''>">

<cfquery name="Store_Var" datasource="Test">
   UPDATE Table
   SET Field = '#Var#'
</cfquery>

When queried, the value of Field in Table is "<cfset value = '>"

Any advice is appreciated.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241997
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to