Quotation replacement conundrum

This is a discussion on Quotation replacement conundrum within the Cold Fusion forums in Application Servers & Tools category; I have some data stored in a database (user inputted data). I need to display this data within xml, and I need all the quotation marks removed (since that would mess up the xml). The logical replacement (to make it look roughly as the user intended) is to replace the quotation marks with apostrophes. But I run into a problem when I try to use REPLACE (see code below). You'll note I end up with 3 apostrophes in a row in my code. Any ideas on how to handle this? <CFSET thisData = #Replace(oldData, '"', ''', "All")#>...