OK, using the HTML replacement worked.... Set my variable from the form to use in the SQL:
<cfset COMV=Replace(Form["COMMENTS_#thisID#"], "'", "’", "all")> ..and then in the SQL Statement: COMMENTS= '#COMV#' Sheesh, was that a pain or what!!! What's odd is that this: COMV=Replace(Form["COMMENTS_#thisID#"], "'", "''", "all"); did NOT work.... ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
