Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Formatting text strings in sql Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-05 : 21:31:41
Hameed writes "I have a textarea field on a form (as shown below)

<textarea name="newsletter" class="input_box" COLS="95" ROWS="15" WRAP="physical"></textarea>

that is fairly big and when this form is submitted, the text initially would have carraige returns in it (as it would have a few paragraphs of text) as the writer is posting an article. When I collect the info from the form I am simply doing a request.form ("newsletter") . I then do an insert into a table in SQL server and then somewhere else on the site I display this record. The problem with this display is that the carraige returns are no longer in the text and it just gets this long text - see this here http://www.ihealthfirst.com/hottopics_detail.asp?8 .
My question is, what character am I looking for when I do my response.write so that I can replace it with a br tag so that the text gets formatted correctly?

Please Help"
   

- Advertisement -