line breaks- store in DB

[ryanbrand]

Hi,
I have a text area that will put it's text in a DB. Later the text will be displayed on the website but not in a text area. How do I store the data so that the line breaks are on the website.

How do I replace the text area breaks with <br>?
Thank you for your help.
Ryan

 

[TruthInSatire]

simple.

<cfoutput>#replace(qMyQuery.MyFieldName, chr(10), "<br>", "All")#</cfoutput>

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[ecobb]

Or, you could just the ParagraphFormat() function when displaying the text.

<cfoutput>#ParagraphFormat(Query.Fieldname)#</cfoutput>

Hope This Helps!

Ecobb

&quot;My work is a game, a very serious game.&quot; - M.C. Escher

 

[ryanbrand]

Thanks a lot! This is very helpful to me.