SQL Server Forums - GetString and text

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Old Forums

CLOSED - General SQL Server

GetString and text

Forum Locked

Printer Friendly

Author

Topic

Pulseware
Starting Member

2 Posts

Posted - 07/26/2006 : 01:55:57

I am trying to use the GetString method of the ADODB.RecordSet object but whenever there is a text data type in my MS SQL database not only is that field blank but all the subsequent fields are blank too.

I know that the text data type does this because of the order of access, but what I want to know is if there is any way I can stop this from happening and still use the GetString method.

Lumbago
Norsk Yak Master

Norway
3241 Posts

Posted - 07/26/2006 : 02:32:45

That would basically be an ASP/ADO-question and you would probably get better help on www.haneng.com or www.webdeveloper.com or something. Here is some info on the GetString method btw...don't know if it will do you any good: http://www.w3schools.com/ado/met_rs_getstring.asp

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Pulseware
Starting Member

2 Posts

Posted - 07/26/2006 : 02:43:23

I will try those sites. W3schools didn't help but thanks anyway.

Kristen
Test

United Kingdom
22191 Posts

Posted - 07/26/2006 : 06:59:43

There used to be a problem with TEXT if it was NOT the last column in the recordset, but I don't think that was specifically related to GetString, but it might be worth a try.

Presumably you have the latest version of ADO installed?

Kristen

Topic

Forum Locked

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.