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.

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.

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.