> I've had this issue - and have it - usually when people cut and paste
> from Word. (Using the "right apostrophe") However I am using MySQL.
> What I do is a find and replace through phpmyadmin... which won't help
> you with Access.
>
> In addition to fixing the DB - You probably need to write a filter in
> the data entry submission as well.
>
> <cfset TextAreaAmended1 = ReplaceNoCase(#FORM.TextArea#, "?","'",
> "All")>
>
> I would guess to update the DB you need to loop through your entries
> and do a replace:
>
>
> - Nick
>
Thank you! I used the <cfoutput>#ASC("funky_char")#</cfoutput> to find out
which character was screwing up. Then I used your code as follows:
<cfset TextAreaAmended1 = ReplaceNoCase(#FORM.TextArea#,"#chr(25)#","'",
"All")>
It works great.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3274
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
