----- Original Message ----- From: "Randell B Adkins" <[EMAIL PROTECTED]> > With the TEXTAREA if I manually type the apostrophes, commas, and > quotes, then it is retained when saving to the database. > > But if Pasted from MS Word, it transforms the apostrophe into a > little square box. ----------------------------
I guess it's cos of the 'smart quotes' in Word, i.e. quotes and apostrophes that look like traditional print quotes and apostrophes - a tiny ball with a curved tail - instead of the monotype-type things with just tiny vertical lines. The latter are part of the standard ASCII character set, the former aren't - I think. This may not be the correct technical explanation, but it's a good ball park for understanding why you get the little boxes when pasting in from Word. Here's some options: - Find the correct character codes for the 'smart quotes' and replace them with the correct escape codes - or plain ASCII quotes - when processing the form server-side. - Try updating the textarea contents client-side with JavaScript along similar lines (not tried this before, but I assume it's feasible). You'd either run the JS from an onchange event handler on the textarea, or have a 'Tidy' button to trigger it in the form. - Go with a WYSIWYG solution like soEdit. HTH, - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
