I'm entering data on a web form, which has 2-3 text paragraphs.

once it's on the server and queried back it returns it into 1 paragraph.
previoiusly, I had the data type set to 'nvarchar' and I changed it to "ntext"

I was told to change the data type to "ntext", but now it's not returning the data entered anymore. even though it's returning the rest of the data from the table.

the original data is still intact in the table, just not able to access the column that was changed to "ntext"

any ideas?

I don't think the data type is a problem, I think you could use ntext, nvarchar, text or varchar.

When you want to display the text on a web page as it was typed into a text area, complete with line breaks try:

<%= Replace(RecorsdsetName.Fields.Item("FieldName".Value, VbCrLf, "<BR>" %>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

There is a problem displaying (n)text on a web page. Solution is to:
1. make ntext be the last field in table
2. select it as the last in SQL.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'm entering data on a web form, which has 2-3 text paragraphs.

once it's on the server and queried back it returns it into 1 paragraph.
previoiusly, I had the data type set to 'nvarchar' and I changed it to "ntext"

I was told to change the data type to "ntext", but now it's not returning the data entered anymore. even though it's returning the rest of the data from the table.

the original data is still intact in the table, just not able to access the column that was changed to "ntext"

any ideas?


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

Viktor Farcic

TalkZone Manager