SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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 Previous Topic Topic Next Topic  

Pulseware
Starting Member

2 Posts

Posted - 07/26/2006 :  01:55:57  Show Profile  Visit Pulseware's Homepage
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
3271 Posts

Posted - 07/26/2006 :  02:32:45  Show Profile
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"
Go to Top of Page

Pulseware
Starting Member

2 Posts

Posted - 07/26/2006 :  02:43:23  Show Profile  Visit Pulseware's Homepage
I will try those sites. W3schools didn't help but thanks anyway.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/26/2006 :  06:59:43  Show Profile
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000