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 2000 Forums
 SQL Server Development (2000)
 ado recordset.getrows() & mssql text/ntext data type

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-26 : 09:51:08
Peter writes "Hey,

I'm using getrows method and it seems
that text field(ntext) can not be saved in array.


Thank you kindly.

Peter."

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-06-26 : 09:54:53
Are you getting an error? Does the returned array have no elements? What's the nature of the problem exactly?

Jonathan Boott, MCDBA
Go to Top of Page

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2002-06-26 : 10:10:21
I wouldn't be surpised if getrows has problems with text fields since they are treated differently from varchar fields.

You might want to make sure the text field is the last field selected in your select clause.

Go to Top of Page
   

- Advertisement -