Have you tried using the Chr() function and passing in the code for them? -Jeff
David Delbridge wrote: > 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:242000 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
