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 2005 Forums
 Transact-SQL (2005)
 no new rows in inserted text

Author  Topic 

Medes
Starting Member

1 Post

Posted - 2008-07-26 : 17:51:41
Hi everybody,

I am using sql server 2005 express and windows server 2003.

I am using usual insert command to insert a text into a table with a column which is ntext. I have used enter key to make new lines in my text when i inserted it to the table but when i browse to another page (on my web site) to show the text the text is only one single line.
i am using following code to show the text.

<p>
<asp:Label Text='<%# Eval("Body") %>' runat="server" ID="descriptionLabel" />
</p>

thanks for your help

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-07-28 : 06:34:18
Your issue seems to be an ASP one rather than an SQL one. Here's a link to a similar issue and a suggested solution...

http://www.velocityreviews.com/forums/t366190-formatting-multiline-text.html


Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page
   

- Advertisement -