|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
strip ntext chars
Hi. I have a database column that is (for now) of type text. (For now) IJohn M Bliss 10/18/12 09:42 A Is this a stumper? Or a stupid question? :-)John M Bliss 10/18/12 01:15 P You're converting from Ntext to Text?Robert Harrison 10/18/12 01:29 P Reread your post. You may want to look at Ben Nadel's blog: http://www.bennadel.com/blog/1155-Cleaning-High-Ascii-Values-For-Web-Safeness-In-ColdFusion.htmRobert Harrison 10/18/12 01:34 P Oh, sweet! Thanks! (I owe Ben SO MANY BEERS. And, of course, Ray.)John M Bliss 10/18/12 01:39 P Ben doesn't drink beer, so I get his.Raymond Camden 10/19/12 09:57 A Fair enough.John M Bliss 10/19/12 10:15 A Hi. I have a database column that is (for now) of type text. (For now) I cannot change it to ntext. What's the best way to use CF to strip out (or replace) characters that require ntext prior to inserting the text. Here's my first attempt which did not seem to work: <cfloop index="charcounter" from="1" to="#len(FileContent)#"> <cfif asc(mid(FileContent, charcounter, 1)) GT 255> <cfset FileContent = replace(FileContent, mid(FileContent, charcounter, 1), "?", "all")> </cfif> </cfloop> -- John Bliss - http://about.me/jbliss Is this a stumper? Or a stupid question? :-) On Thu, Oct 18, 2012 at 8:42 AM, John M Bliss <bliss.john@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more ----- -- John Bliss - http://about.me/jbliss You're converting from Ntext to Text? Robert Harrison Director of Interactive Services Austin & Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ Reread your post. You may want to look at Ben Nadel's blog: http://www.bennadel.com/blog/1155-Cleaning-High-Ascii-Values-For-Web-Safeness-In-ColdFusion.htm Robert Harrison Director of Interactive Services Austin & Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi Oh, sweet! Thanks! (I owe Ben SO MANY BEERS. And, of course, Ray.) On Thu, Oct 18, 2012 at 12:34 PM, Robert Harrison < robert@austin-williams.com> wrote: ----- Excess quoted text cut - see Original Post for more ----- Ben doesn't drink beer, so I get his. On Thu, Oct 18, 2012 at 12:38 PM, John M Bliss <bliss.john@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more ----- Fair enough. On Fri, Oct 19, 2012 at 8:56 AM, Raymond Camden <raymondcamden@gmail.com>wrote: ----- Excess quoted text cut - see Original Post for more -----
|
May 21, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
