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 Subject: apostrophe in access db field If you have an apostrophe in an access db text or memo field it shows as a block or question mark in Internet Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 articles to our site, and most of the time, they are just copying and pasting from Word to the textarea, which mucks things up. I've found that this tag works wonders with that app. Charlie Griefer wrote: 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 Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 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 articles to our site, and most of the time, they are just copying and pasting from Word to the textarea, which mucks things up. I've found that this tag works wonders with that app. Charlie Griefer wrote: 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 Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 on Macromedia.com. Here's the URL for the tag: http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Exchange%20Search%20Detailsloc=en_usauthorid=35342110page=0scrollPos=0subcatid=0snid=sn106itemnumber=0extid=1000714catid=0 Or: http://tinyurl.com/92vy8 Tim Laureska wrote: 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 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 articles to our site, and most of the time, they are just copying and pasting from Word to the textarea, which mucks things up. I've found that this tag works wonders with that app. Charlie Griefer wrote: 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 Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 on Macromedia.com. Here's the URL for the tag: http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName =Exchange%20Search%20Detailsloc=en_usauthorid=35342110page=0scrollPo s=0subcatid=0snid=sn106itemnumber=0extid=1000714catid=0 Or: http://tinyurl.com/92vy8 Tim Laureska wrote: 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 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 articles to our site, and most of the time, they are just copying and pasting from Word to the textarea, which mucks things up. I've found that this tag works wonders with that app. Charlie Griefer wrote: 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 Explorer. how can you work around that? Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54