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.
| Author |
Topic |
|
Pulseware
Starting Member
2 Posts |
 Posted - 2006-07-26 : 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
3271 Posts |
Posted - 2006-07-26 : 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 - 2006-07-26 : 02:43:23
|
| I will try those sites. W3schools didn't help but thanks anyway. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-26 : 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 |
|
|
|
|
|
|
GetString and text