ASP - Line Break in SQL Value

Author

Line Break in SQL Value

James

2005-06-06, 3:55 pm

We've built a page that allows users to enter items that will ultimately
become a list. One particular user enters them into the textarea on the
page and for some reason always puts a hard return into the textarea before
she submits. This goes into SQL as a line break and it's screwing up how
the page renders.

How do I find this via code so that I can replace it? I've tried looking
for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but it
doesn't seem to work. Am I missing something?

Thanks,
James

b.Wurm

2005-06-06, 3:55 pm

Hello!

chr(13) + Chr(10) is the same as vbCrLf.
Did you allready try vbLf?

regards
b.wurm

"James" <letyoudown@verizon.net> schrieb im Newsbeitrag
news:uQ8yxwpaFHA.2520@TK2MSFTNGP09.phx.gbl...
> We've built a page that allows users to enter items that will ultimately
> become a list. One particular user enters them into the textarea on the
> page and for some reason always puts a hard return into the textarea
> before
> she submits. This goes into SQL as a line break and it's screwing up how
> the page renders.
>
> How do I find this via code so that I can replace it? I've tried looking
> for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but
> it
> doesn't seem to work. Am I missing something?
>
> Thanks,
> James
>
>

Sponsored Links