The application is a Flex front end, Coldfusion 9 middle tier and MySQL back end. I am using a RichTextEditor in the Flex front end text boxes so that users have an option of formatting. However, some users copy and paste content from MS-Word documents and some formatting like the square box
2010: cannot be stored at the MySQL back end(version 5.5.27) so there is an error when such formatting is tried to be added to the tables. I realize one way is to use the ReReplace function in Coldfusion to replace the special formatting characters with blank, but since there might be hundreds of special formatting characters like the in MS-Word, I cannot not know which are the possible special formatting characters which need to be replaced. I cannot use the Textarea.text property to remove all formatting since if someone underlines or changes the color of text, that needs to be stored in the tables so that next time the record is retrieved, the underlined should show below the text 1. Is there a way I can convert just the special formatting characters to regular formatting like a • which can be stored in the MySQL tables or just remove the special formatting characters in Flex? ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
