Problem displaying SQL Server "text" datatype

[multiplex77]

Hi,

Is there any known issue with displaying MS SQL Server 7 "text" datatypes using ASP resultsets?

When I try to display a text field, I just get an empty string (but no error). It's only when I change the field datatype to varchar(100), then the contents of that field get displayed.

Does this happen with other databases or versions of SQL Server?

Thanks for any advice.

 

[codestorm]

text/ntext, etc fields have to be handled differently - look up GetChunk in ADO help. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[culshaja]

If you retrieve a text field using a stored procedure then it comes safely out of the recordset without using GetChunk.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[jlgdeveloper]

Having the latest service packs sometimes fixes these issues. Jonathan Galpin

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0

 

[Funka]

try retrieving the text datatype separately from other datatypes (in a separate recordset.) i've also heard having it as the last column retrieved in a recordset helps, but i've had mixed success with that.

good luck!

 

[Tarwn]

Well, just to be a blatant pain
I never had that problem
Course, if I were you I would stick with varchar because I did find out after using texrt for a while why I kept having large amounts of whitespace after all of the data i pulled out of a textfield. varchar doesn't pad it's entries so I prefer because I am to lazy to trim every single time I print something from the db.
-Tarwn

 

[skotman]

Well, I had this same problem and found that if you reference the Text field LAST in the SQL statement it works. Not sure why but it does.

 

[dirkg]

I use a stored procedure to retrieve the data but still I get no result on my page.... :-(