Yes, you can use the Replace() function:

<cfoutput>
#Replace(myQuery.htmlText, Chr(10), "<br>")#
</cfoutput>

----- Original Message -----
From: S R <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, October 30, 2000 7:00 PM
Subject: insert <br>


> Hi,
>
> I am creating a page that calls a text field from a SQL database. Some
lines
> of the text look like this:
>
> ....a new section that will be offered.
>
> Group Sales______________________________________The group sales that will
> be offered......
>
> By I need it to look like this:
>
> ....a new section that will be offered.
>
> Group Sales______________________________________
>
> The group sales that will be offered......
>
> So basically I need to parse through each message and insert a <br> at the
> end of these "lines" that appear. Would a "Replace" function be a good
place
> to start?
>
> Sal
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to