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
 Other Forums
 Other Topics
 grabing line breaks from a varchar field stored in MS SQL7

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-21 : 22:25:44
Steve writes "Oh Great SQl GURU, I have travelled far and wide searching for the answer to a question that has perplexed mankind for generations (or at least my self for quite some time now).

I have a field that data has been entered into (via a Visual Basic Application that I have created) and when I display that field in an asp page, I want the line breaks to still work I mean, when the user inputs a line break in the field, I want that line break to display in the HTML.

Now as a work around I have used textareas which do pick up the line breaks correctly, however, since this is a report (meant for printing) I can't use a textarea as if I make it to small, not all of the text will print, and if I make it to large a whole lot of white space...


ARGH...the hours of sleep that I have lost over this one.

Can you help?

Steve
(MSSQL 7 Service Pack 2. ASP running on Windows 2000 (SP1) and IIS 5)."
   

- Advertisement -