RE: apostrophe in access db field

Use the Acccess with Unicode driver in the cf admin when setting up the datasource. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:41 PM To: CF-Talk

Re: apostrophe in access db field

sounds like a 'smart quote' (one of those curly MS Word quotes). there's a UDF called demoronize() at cflib that should handle this. On 1/9/06, Tim Laureska [EMAIL PROTECTED] wrote: If you have an apostrophe in an access db text or memo field it shows as a block or question mark in Internet

Re: apostrophe in access db field

There's also a tag out there called StripAscii that is intended to strip out MS Word high-ascii chars. I think it's called CF_StripAsci, and I *think* I got it on the DevEx. I use it all the time to reformat text submitted via a textarea in a form. We have a place where users can post

RE: apostrophe in access db field

Ray... thanks... what's the base url for devex... is this expert exchange you're referring to? thanks Tim -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 2:14 PM To: CF-Talk Subject: Re: apostrophe in access db field There's also a tag

Re: apostrophe in access db field

: Monday, January 09, 2006 2:14 PM To: CF-Talk Subject: Re: apostrophe in access db field There's also a tag out there called StripAscii that is intended to strip out MS Word high-ascii chars. I think it's called CF_StripAsci, and I *think* I got it on the DevEx. I use it all the time

RE: apostrophe in access db field

THANKS! Tims -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 4:10 PM To: CF-Talk Subject: Re: apostrophe in access db field I'll do ya one better. I just searched for it. FYI, as you'll see, I meant the Developer Exchange