this should be simple for those who've done it already.

I'm entering data on a web form, it could be from a 2-4 sentence with double lines.

when I query it back, it returns it all in 1 sentence.

I've set the original data type to "nvarchar", but was told to change it to "ntext". SQL 2000 tells me that I could lose data but still I proceeded. after switching to "ntext" it no longer shows it once queried.

from the sql database, the entered data was there and the interesting thing that I noticed is that it had "||" after every sentence. assuming that it took the double lines.

wondering as to why it's not showing the text and would like the query to output the text properly.


thanks in advance!

Change the Memo field wrap to "virtual." This is found in the memo fields properties

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
this should be simple for those who've done it already.

I'm entering data on a web form, it could be from a 2-4 sentence with double lines.

when I query it back, it returns it all in 1 sentence.

I've set the original data type to "nvarchar", but was told to change it to "ntext". SQL 2000 tells me that I could lose data but still I proceeded. after switching to "ntext" it no longer shows it once queried.

from the sql database, the entered data was there and the interesting thing that I noticed is that it had "||" after every sentence. assuming that it took the double lines.

wondering as to why it's not showing the text and would like the query to output the text properly.


thanks in advance!


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Download this extension using the below link and apply it to your dymanic text link on your display page, works a treat for me.

www.udzone.com/showDetail.asp?TypeId=3&NewsId=1931<font color=navy></font id=navy>

Iain