Do a replace of "LOGGED BY" with "<br>LOGGED BY", either in the db or in CF.
In t-sql, you could use
SELECT replace(commentfield,'LOGGED BY','<BR>LOGGED BY') as comment
FROM ....
-----Original Message-----
From: Joseph Vincent [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 12:40 PM
To: CF-Talk
Subject: breaks inside a selected DB field
I am selecting a database field that has comments in it. Some of these
comments can be quite long. I am wondering if there is a way for me to
insert a breaks when I am outputting that field? I would want it to break
every time there is LOGGED BY in the text,which is the start of a new
comment.
_________________________________________________________________________
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]
