convert string to safe string before adding to database

[forums.macromedia.com]

Hi

I am updating a site for a client who is running CF5. The update and insert
queries break when the user uses inverted commas ". I currently have a
script which does the following:

<cfscript>
content = ReplaceNoCase(attributes.content,"&##x93;","&quot; ","ALL");
content = ReplaceNoCase(content,"&ldquo;","&quot;","ALL");
content = ReplaceNoCase(content,"&lsquo;","&##8216;","ALL");
content = ReplaceNoCase(content,"&##x94;","&quot;","ALL");
content = ReplaceNoCase(content,"&rdquo;","&quot;","ALL");
content = ReplaceNoCase(content,"&rsquo;","&##8216;","ALL");
content = ReplaceNoCase(content,"&##x91;","&##8216;","ALL");
content = ReplaceNoCase(content,"&##x92;","&##8216;","ALL");
content = ReplaceNoCase(content,"&##x96;","-","ALL");
content = ReplaceNoCase(content,"&ndash;","-","ALL");
content = ReplaceNoCase(content,""","&quot;","ALL");
content = ReplaceNoCase(content,""","&quot;","ALL");
content = ReplaceNoCase(content,"'","&##8217;","ALL");
content = ReplaceNoCase(content,"'","&##8217;","ALL");
content = ReplaceNoCase(content,"'","&##8217;","ALL");
content = ReplaceNoCase(content,"'","&##8217;","ALL");
content = ReplaceNoCase(content,"-","-","ALL");
content = ReplaceNoCase(content,"£","&pound;","ALL");
content = ReplaceNoCase(content,"""","&quot;","ALL");
caller.result = content;
</cfscript>

but the inverted commas are still breaking the script. The database is
access.

any help or advice appreciated!!

Shaun

[vkunirs]

Hi

can you try with PreserveSingleQuotes ?
will it works for your situation.?
can you post your final update query (The dynamic query generate by your program).