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
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. 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? 2. I realize one way is to use the ReReplace function in Coldfusion to repalce 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 underline needs to show below the text I am using compiler Flex 4.5 with Flex 3 compatibility mode. Any suggestions would be appreciated. -- You received this message because you are subscribed to the Google Groups "Flex India Community" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/flex_india?hl=en.
