Try replacing the Line Feeds after you've removed the carriage returns.
 
<cfset entry = ReplaceNoCase(form.entry, chr(13), "", "all")>
<cfset entry = ReplaceNoCase(entry, chr(10), "", "all")>
-----Original Message-----
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 6:20 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] CFMX AND DSNs

I used <cfset entry = ReplaceNoCase(form.entry, chr(13), "", "all")>
and got no dice. On top of that im getting strange stuff in the tables. Usually when I look at the data and there is a return char in SQL Server it looks like two thick pipes. When i run this i get squares insted of spaces.
 
Adaryl Wakefield
Aviator by passion
Programmer by sheer force of will
----- Original Message -----
From: Robert
Sent: Thursday, October 30, 2003 5:52 PM
Subject: Re: [KCFusion] CFMX AND DSNs

Adaryl,
 
Why not use a ReReplaceNoCase and replace your chr(13) which is a carriage return with something else..i've used a replace for chr(13) with a <br> for html formatting a textarea box.
 
Thanks,
Robert
----- Original Message -----
Sent: Thursday, October 30, 2003 5:36 PM
Subject: Re: [KCFusion] CFMX AND DSNs

I have an app that creates some XML on the fly from info dug out of an database that is used by a swf. The problem is that Flash7 seems to choke on char returns.
What can I do to clean out char returns from a <textarea>?
 
 
Adaryl Wakefield
Aviator by passion
Programmer by sheer force of will

Reply via email to