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

[Gérard Leclercq]

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

[Aaron [SQL Server MVP]]

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

--
http://www.aspfaq.com/
(Reverse address to reply.)


"WC Justice" <BJ******@wcje.com> wrote in message
news:sQ******************@bignews3.bellsouth.net.. .

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

[Ray Costanzo [MVP]]

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

Ray at work
"WC Justice" <BJ******@wcje.com> wrote in message
news:sQ******************@bignews3.bellsouth.net.. .

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

[WC Justice]

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

"Gérard Leclercq" <ge*************@pas-de-mail.fr> wrote in message
news:DX*******************@phobos.telenet-ops.be...

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

[Hal Rosser]

"WC Justice" <BJ******@wcje.com> wrote in message
news:sQ******************@bignews3.bellsouth.net.. .

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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.817 / Virus Database: 555 - Release Date: 12/15/2004