Asp Sql Puzzle?

[Dean]

Hi their

Can any body help me i am using dreamweaver mx and sql 2000 and if i set a field in the table to ntext then it will not appear on the page when i run it on the server i mearly get a nothing.

But due to the fact this field needs to be able to holde upto 8000 chars nvarchar will just ot handle the amount of data that needs to be input.

I checked the code and if i change the feild to nvarchar then i get some of the the info but end up cutting the bottom half off some of the text.

:confused: :confused: :confused: :confused:

any sugestions wellcome

[aCcodeMonkey]

Dean,


When you say you cannot see the text. Do you mean in the "Live Data View", or when you press F12 and preview the code in the browser via the "Test Server"?

A couple things to try

1) Remember that the NVarChar field is actually an Image field not a text field. Try wrapping the output in a CStr() function.

i.e. CStr(oRs.Fields("myField").Value)

2) Are you useing an ADODB.Connection or SQLOLEDB Provider for your connection?

3) It may also be a caching issue on your webserver.


Hope This helps

:cool: :cool: