Carriage Return and Response.Write Output Issue

[crjunk]

I have a field in a SQL Server table named DetailedDescrip tion that is
a varchar. If the user adds/edits a detailed description, they do so
in a MulltiLine TextBox control. Therefore, they are able to click
enter on their keyboard and have multiple carriage returns inside the
DetaildDescript ion.

My problem is that I have another webpage in my project that has the
following statement in it:
Response.Write( drSQL.Item("Det ailDescription" )).

If the user created a record in the following format:
HELLO
WORLD

It is now displayed as:
HELLO WORLD

Is there something I can add to my Response.Write statement so that the
carriage returns are "written" so that the output is in the following
format:
HELLO
WORLD

I hope this makes sense.
Thanks,
CR Junk

[gomer]

Response.Write( Replace(vbCrLf, "<br>"))

"crjunk" <cr****@earthli nk.netwrote in message
news:11******** **************@ c28g2000cwb.goo glegroups.com.. .

>I have a field in a SQL Server table named DetailedDescrip tion that is
a varchar. If the user adds/edits a detailed description, they do so
in a MulltiLine TextBox control. Therefore, they are able to click
enter on their keyboard and have multiple carriage returns inside the
DetaildDescript ion.

My problem is that I have another webpage in my project that has the
following statement in it:
Response.Write( drSQL.Item("Det ailDescription" )).

If the user created a record in the following format:
HELLO
WORLD

It is now displayed as:
HELLO WORLD

Is there something I can add to my Response.Write statement so that the
carriage returns are "written" so that the output is in the following
format:
HELLO
WORLD

I hope this makes sense.
Thanks,
CR Junk

[Bob Barrows [MVP]]

crjunk wrote:

I have a field in a SQL Server table named DetailedDescrip tion that is
a varchar. If the user adds/edits a detailed description, they do
so in a MulltiLine TextBox control. Therefore, they are able to
click enter on their keyboard and have multiple carriage returns
inside the DetaildDescript ion.

My problem is that I have another webpage in my project that has the
following statement in it:
Response.Write( drSQL.Item("Det ailDescription" )).

If the user created a record in the following format:
HELLO
WORLD

It is now displayed as:
HELLO WORLD

Is there something I can add to my Response.Write statement so that
the carriage returns are "written" so that the output is in the
following format:
HELLO
WORLD

A. Display the data in a textarea instead of response.writin g it into
the html
B. Surround the data in <PRE></PREtags
C. Replace the carriage returns with <BR- this is basic html.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[crjunk]

Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk

[Firas]

Hi, if i were you, i would use the same as Gomer's but with little
modification
Response.Write( replace(drSQL.I tem("DetailDesc ription"),chr(1 3),"<BR>")

what i did is that i replaced the vbCrLf to chr(13), because the vbCrLf
is combination of chr(13) and chr(10), so what if the user had used a
format that he only included the chr(13), then if you use the vbCrLf it
will not work, because using the vbCrlf will look for the two at once
which only one is available. And by the way, according to me testings,
chr(13) is required for the enter more than the chr(10) which means
chr(10) is always to occure.
And if you still want to use his advice, then use it this way: use vbCr
instead of chr(13)
Best Regards
Firas S Assaad
crjunk wrote:

Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk

[Anthony Jones]

"Firas" <fi******@gmail .comwrote in message
news:11******** **************@ m7g2000cwm.goog legroups.com...

Hi, if i were you, i would use the same as Gomer's but with little
modification
Response.Write( replace(drSQL.I tem("DetailDesc ription"),chr(1 3),"<BR>")

what i did is that i replaced the vbCrLf to chr(13), because the vbCrLf
is combination of chr(13) and chr(10), so what if the user had used a
format that he only included the chr(13), then if you use the vbCrLf it
will not work, because using the vbCrlf will look for the two at once
which only one is available. And by the way, according to me testings,
chr(13) is required for the enter more than the chr(10) which means
chr(10) is always to occure.
And if you still want to use his advice, then use it this way: use vbCr
instead of chr(13)

There are two end-of-line markers in common use. CRLF or just plain LF.
I've not come across many (in fact never have) systems that only use CR.
What tests did you use to discover that CR on it's own is more common or
indeed ever happens at all?

My solution BTW is :-

Replace(Replace (Server.HTMLEnc ode(s), vbCR, ""), vbLF, "<br />")

>
Best Regards
Firas S Assaad
crjunk wrote:

Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk

[XML noob]

we're talking about someone hitting the enter key in text area on a web
page...
how would this ever be translated into anything other than crlf??
"Anthony Jones" <An*@yadayadaya da.comwrote in message
news:eN******** ******@TK2MSFTN GP04.phx.gbl...

>
"Firas" <fi******@gmail .comwrote in message
news:11******** **************@ m7g2000cwm.goog legroups.com...

>Hi, if i were you, i would use the same as Gomer's but with little
modification
Response.Write (replace(drSQL. Item("DetailDes cription"),chr( 13),"<BR>")

what i did is that i replaced the vbCrLf to chr(13), because the vbCrLf
is combination of chr(13) and chr(10), so what if the user had used a
format that he only included the chr(13), then if you use the vbCrLf it
will not work, because using the vbCrlf will look for the two at once
which only one is available. And by the way, according to me testings,
chr(13) is required for the enter more than the chr(10) which means
chr(10) is always to occure.
And if you still want to use his advice, then use it this way: use vbCr
instead of chr(13)

There are two end-of-line markers in common use. CRLF or just plain LF.
I've not come across many (in fact never have) systems that only use CR.
What tests did you use to discover that CR on it's own is more common or
indeed ever happens at all?

My solution BTW is :-

Replace(Replace (Server.HTMLEnc ode(s), vbCR, ""), vbLF, "<br />")

>>
Best Regards
Firas S Assaad
crjunk wrote:

Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk

[Bob Barrows [MVP]]

I think that's exactly Anthony's question. Perhaps Firas is aware of a
browser that will use vbCr instead of vbCrLf.

XML noob wrote:

we're talking about someone hitting the enter key in text area on a
web page...
how would this ever be translated into anything other than crlf??
"Anthony Jones" <An*@yadayadaya da.comwrote in message
news:eN******** ******@TK2MSFTN GP04.phx.gbl...

>>
"Firas" <fi******@gmail .comwrote in message
news:11******* *************** @m7g2000cwm.goo glegroups.com.. .

>>Hi, if i were you, i would use the same as Gomer's but with little
modificatio n

Response.Write( replace(drSQL.I tem("DetailDesc ription"),chr(1 3),"<BR>")

>>>
what i did is that i replaced the vbCrLf to chr(13), because the
vbCrLf is combination of chr(13) and chr(10), so what if the user
had used a format that he only included the chr(13), then if you
use the vbCrLf it will not work, because using the vbCrlf will look
for the two at once which only one is available. And by the way,
according to me testings, chr(13) is required for the enter more
than the chr(10) which means chr(10) is always to occure.
And if you still want to use his advice, then use it this way: use
vbCr instead of chr(13)

There are two end-of-line markers in common use. CRLF or just plain
LF. I've not come across many (in fact never have) systems that only
use CR. What tests did you use to discover that CR on it's own is
more common or indeed ever happens at all?

My solution BTW is :-

Replace(Replac e(Server.HTMLEn code(s), vbCR, ""), vbLF, "<br />")

>>>
Best Regards
Firas S Assaad
crjunk wrote:
Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Anthony Jones]

"XML noob" <le**@s.comwrot e in message
news:Ox******** ******@TK2MSFTN GP02.phx.gbl...

we're talking about someone hitting the enter key in text area on a web
page...
how would this ever be translated into anything other than crlf??

If you pass stuff around via XML you will find CRLFs being converted to just
LFs.

>
"Anthony Jones" <An*@yadayadaya da.comwrote in message
news:eN******** ******@TK2MSFTN GP04.phx.gbl...

"Firas" <fi******@gmail .comwrote in message
news:11******** **************@ m7g2000cwm.goog legroups.com...

Hi, if i were you, i would use the same as Gomer's but with little
modification
Response.Write( replace(drSQL.I tem("DetailDesc ription"),chr(1 3),"<BR>")

what i did is that i replaced the vbCrLf to chr(13), because the vbCrLf
is combination of chr(13) and chr(10), so what if the user had used a
format that he only included the chr(13), then if you use the vbCrLf it
will not work, because using the vbCrlf will look for the two at once
which only one is available. And by the way, according to me testings,
chr(13) is required for the enter more than the chr(10) which means
chr(10) is always to occure.
And if you still want to use his advice, then use it this way: use vbCr
instead of chr(13)

There are two end-of-line markers in common use. CRLF or just plain LF.
I've not come across many (in fact never have) systems that only use CR.
What tests did you use to discover that CR on it's own is more common or
indeed ever happens at all?

My solution BTW is :-

Replace(Replace (Server.HTMLEnc ode(s), vbCR, ""), vbLF, "<br />")

>
Best Regards
Firas S Assaad
crjunk wrote:
Thanks for the responses. I ended up using Gomer's suggeetion.

CR Junk