Mat, Do you mean the "Smart Tags"? Try the following before your insert:
<cfset newtext = Replace(newtext, chr(145), chr(39),"ALL")> <!--- "single open" ---> <cfset newtext = Replace(newtext, chr(146), chr(39),"ALL")> <!--- "single closed" ---> <cfset newtext = Replace(newtext, chr(147), chr(34),"ALL")> <!--- "dbl open" ---> <cfset newtext = Replace(newtext, chr(148), chr(34),"ALL")> <!--- "dbl close" ---> <cfset newtext = Replace(newtext, chr(150), chr(45),"ALL")> <!---"short hyphen" ---> <cfset newtext = Replace(newtext, chr(151), chr(45),"ALL")> <!---"long hyphen" ---> <cfset newtext = Replace(newtext, chr(133), "&##133;","ALL")> <!--- "elipsis" ---> Regards, Steve c -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Bryant Sent: Wednesday, 3 March 2004 10:38 AM To: CFAussie Mailing List Subject: [cfaussie] Bad Characters Anyone out there come across the issue and even better, a fix, for copying and pasting a word document that contains "Inverted Commas" into soEditor (or other WYSIWIG HTML Editor) and it saves dodgey characters (squares, instead of Inverted Commas) into the database (mySQL). Regards, mat. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
