displaying carriage returns from database query

[adellamx]

hi i'm fairly new to colfusion but have a good basic understanding.

i'm trying to build a community website that has a guestbook and forums. i want to build these from scratch.

i'm using cfmx7 and sqlserver 2005.

the problem i'm having is when my cfm page retrieves posts made to the guestbook or forum, the carriage return characters are missing. posts are coming out all on one line.

how do i get the retrieved posts to display new lines and paragraphs the way they were input into the database?

just like these forums do?

thanx so much. adella.

[drforbin1970]

How are you displaying the output? Include some code.

[aglaun]

Here is the code. Just replace body with your db field name.

<cfoutput>
#Replace(body, newLine, "<br>", "ALL")#
</cfoutput>

[Mr_Black]

...or:

<cfoutput><pre>#textFromDatabase#</pre></cfoutput>