Space between paragraph when pulling text from DB

[DrumAt5280]

When pulling text information from my DB that I know is formatted correct with spaces between paragraphs I get all one string of text without spaces when i view it on the outputted page.

Is there a html tag in need to wrap around the text to have it formatted like i see in my MySQL DB with spaces betwen paragraphs?

Thanks

 

[ChrisHirst]

<pre> </pre>

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[DrumAt5280]

Chris,

Thanks, I just tried that tag and it worked, however now i lost my word wrap (each paragraph runs off the screen in one long single line).

Is the a function of how i got it in to the DB or is it the HTML tag?

Thanks.

 

[JediBMC]

When you are "pulling" the data from the database, are you using ASP? If so, you can use the replace() function to replace the line feed with an HTML element. It should look something like this: (Where Blah is the field from the database.)

replace(Blah, char(10), "<br>")

-Brian-
I'm not an actor, but I play one on TV.

 

[DrumAt5280]

Jedi,

I tried the following but it didn't work. Still no spaces between paragraphs - i know it the REReplace tag works because i replaced "char(10)" below with a word i know is in the query and it worked fine creating the space.

<cfset dbvDescrip=REReplace(GetAd.rentaladdescription,'char(10)','<br><br>','All' )>
<p><cfoutput>#dbvDescrip#</cfoutput></p>

I am a Coldfuion guy.

I like your line of thinking, i just don't know much about char(10). I am not finding much about it yet on Google.

I am using <cfcontent type="text/html; charset=ISO-8859-1"> if that helps at all.

 

[Vragabond]

forum232. You will get your answer quickly there.

 

[DrumAt5280]

I figured it out:

<cfset dbvDescrip=REReplace(GetAd.rentaladdescription,'#chr(13)##chr(10)#','<br>','All' )>
<p><cfoutput>#dbvDescrip#</cfoutput></p>

The #chr(13)##chr(10)# makes it work.