ASP site CRLF commands

[WC Justice]

I have a database-driven web site that uses SQL Server for the back end, ASP
for the wide front end and Access for the local front end. I have nvarchar
fields that sometimes include paragraph breaks. There is no special command
("Enter" works fine) to force the paragraph break in Access, and the text
boxes on the web site recognize these paragraph breaks. I use text boxes
only when I am making editing available to the qualified user. When I want
to display the text in read only, I simply populate an html table cell with
the text. The problem is that the html table cell does not recognize the
paragraph breaks, so the text is displayed in run-on fashion.

I am assuming that I could use the REPLACE function at the point of display
to recognize and either replace or insert a paragraph break command that
html would recognize, but I have no idea either what to look for or what to
replace it with. Can you help?

p.s. I like the html table cell display because it grows to the size of the
text, which the text box does not (or at least I don't know how to make it
do that).

Thanks

 

[Aaron [SQL Server MVP]]

You need to replace with "<br>". See http://www.aspfaq.com/2188

 

[Gérard Leclercq]

Response.Write Replace(MyText,vbCrlf,"<br>")
Response.Write Replace(MyText,Chr(10)&Chr(13),"<br>")
or a variant

 

[Ray Costanzo [MVP]]

sTheText = oYourRecordset.Fields.Item("yourColumn").Value
Response.Write Replace(sTheText, vbCrLf, "<br>")

Ray at work

 

[WC Justice]

Replace(MyText,vbCrlf,"<br>") worked perfectly...thanks to all who
responded!

 

[Hal Rosser]

I have a database-driven web site that uses SQL Server for the back end, ASP
for the wide front end and Access for the local front end. I have nvarchar
fields that sometimes include paragraph breaks. There is no special command
("Enter" works fine) to force the paragraph break in Access, and the text
boxes on the web site recognize these paragraph breaks. I use text boxes
only when I am making editing available to the qualified user. When I want
to display the text in read only, I simply populate an html table cell with
the text. The problem is that the html table cell does not recognize the
paragraph breaks, so the text is displayed in run-on fashion.

I am assuming that I could use the REPLACE function at the point of display
to recognize and either replace or insert a paragraph break command that
html would recognize, but I have no idea either what to look for or what to
replace it with. Can you help?

p.s. I like the html table cell display because it grows to the size of the
text, which the text box does not (or at least I don't know how to make it
do that).

Thanks

If you need to preserve the line returns, one solution is put the <pre>
around the data