Unfortunately, that didn't work as I expected because instead of doing this:

Group Sales______________________________________

The group sales that will be offered......

The replace function does this:

Group Sales<p><p><p><p><p><p><p><p><p><p><p>

The group sales that will be offered......

The ideal way to do it would be to somehow get the last "linefeed" and add a 
"<p>" after it. Or else capture these multiple "linefeeds" in a variable and 
replace it with whatever I want such as maybe 5 linefeeds and a <p>. I know 
what I have to do but I have no idea how to go about it. Any suggestions, 
PLEASE!!!!!

Thanks

Sal


>From: "David Gassner" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: insert <br>
>Date: Mon, 30 Oct 2000 11:17:09 -0000
>
>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]

_________________________________________________________________________
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]

Reply via email to