Nope. Already tried that. No change either way. >PreserveSingleQuotes() > >-- >Jeff > >-----Original Message----- >From: David Delbridge [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 01, 2006 5:01 PM >To: CF-Talk >Subject: Disappearing Single-Quote > >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:241999 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
