Data Retrieval (un)formats my paragraphs

MikeFantana

Hi,

I have a database driven website. Im using SQL 2000 and ASP. Basically Im inserting blocks of paragraphs into the DB which is fine. When I look in the column in the DB, it holds its paragraph integrity but when I try to output it, it drops all the breaks etc and it comes out as one big blob of text.

Is there anything I can do to retain the paragraph formatting.

Thanks

ChRoMe

MikeFantana wrote: »

Hi,

I have a database driven website. Im using SQL 2000 and ASP. Basically Im inserting blocks of paragraphs into the DB which is fine. When I look in the column in the DB, it holds its paragraph integrity but when I try to output it, it drops all the breaks etc and it comes out as one big blob of text.

Is there anything I can do to retain the paragraph formatting.

Thanks

Include the html tags in the data thats inserted into the database, to retain the formatting.

MikeFantana

damn you dreamweaver....:)

How do i automatically put those tags. Is there a script or something I can run at the insert statement.

Graham

Simplest method:

when you return the text from the database, replace the newline with a[HTML]<br>[/HTML]

<%=replace(myData, vbNewLine, "<br />")%>

If you want to get a bit fancier, put a [HTML]<p>[/HTML] tag at the start of the data returned, a [HTML]</p>[/HTML] tag at the end and replace double vbNewLine with [HTML]</p><p>[/HTML]

These methods have the advantage of not having to edit the existing data in your database.