ntext formatting

[Darren Woodbrey]

I have an ASP page that submits a form to a SQL database. There is a
textarea that submits to an ntext field. When I output this to an ASP page
using a Select statement it is all one string. Is there a way to make this
appear exactly like the user enters it into the original text box? I have
tried wrap=hard. When I look at the field in the database it looks like it
was entered but when it is outputted to the page, it is still one string.
Any help would be greatly appreciated. Thanks!

Darren

[Ray at]

The key isn't to get your data to look like it, it's to think about how the
HTML has to be written to get the data to be displayed the way you want it.

How about:
sValueFromDB = Replace(sValueFromDB, vbCrLf, "<br>")

Ray at work

"Darren Woodbrey" <darrenwoodbrey@hpfairfield.com> wrote in message
news:Ou$wliBKEHA.3084@TK2MSFTNGP11.phx.gbl...

> I have an ASP page that submits a form to a SQL database. There is a
> textarea that submits to an ntext field. When I output this to an ASP

page

> using a Select statement it is all one string. Is there a way to make

this

> appear exactly like the user enters it into the original text box? I have
> tried wrap=hard. When I look at the field in the database it looks like

it

> was entered but when it is outputted to the page, it is still one string.
> Any help would be greatly appreciated. Thanks!
>
> Darren
>
>