insert br

2000-10-30 Thread S R 

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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: insert br

2000-10-30 Thread David Gassner 

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/cf-talk@houseoffusion.com/
 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: insert br

2000-10-30 Thread S R 

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 Salesppp

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 -

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/cf-talk@houseoffusion.com/
  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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]