problem diplaying ASP

[kegathor]

Hi,
Im inserting data into a SQL2000 table with breaks/paragraphs and returning it on an ASP (VBScript) page without the breaks.

The information is going into the table as follows;

The quick brown fox jumps
over a lazy dog. The quick brown
fox jumps over a lazy dog.

But its returning like so

The quick brown fox jumps over a lazy dog. The quick brown fox jumps over a lazy dog.

Basically its not holding its inserted structure when its being returned to the page. Is there any coding i can use to keep its structure.

[padtes]

ASP return HTML to browser. HTML understands <BR /> as break, not new line character. So replace your new line with <BR /> after you fetch from DB and write to response.

[jamesschmidth]

You must me using </ br> brak tag ... if u could send me the code i can better tell u that what is wrong

[chsab420]

replace(yourDbField,vbcrlf,"<br>")
this is ur solutions