[thelist] ASP RecordSet weirdness
Ken Schaefer
ken at adOpenStatic.com
Thu Apr 1 19:19:27 CST 2004
What are the field types? If you have a text/blob field, you may need to
modify your code to use .GetChunk.
Anthony has mentioned "a bug" - actually it's not a bug, it's caused by the
fact that ADO doesn't know how big a text/memo field actually is.
http://support.microsoft.com/?id=200124
The next article explains why this is occuring
http://support.microsoft.com/default.aspx?scid=kb;EN-US;175239
This shows how to use .GetChunk and .AppendChunk
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975
Cheers
Ken
----- Original Message -----
From: "Tab Alleman" <Tab.Alleman at MetroGuide.com>
To: <thelist at lists.evolt.org>
Sent: Friday, April 02, 2004 7:33 AM
Subject: [thelist] ASP RecordSet weirdness
I have a recordset open. I'm using ASP 3, SQL2k.
When I do this in my code, everything is fine:
Str1 = rs("field1")
Str2 = rs("field2")
Str3 = rs("field3")
All 3 fields have stuff in them, as they should. But when I do this:
Str1 = rs("field1")
Str3 = rs("field3") 'order of 2 & 3 reversed
Str2 = rs("field2")
...field2 is either NULL or empty. So just for fun, I tried this:
Str2 = rs("field2")
Str3 = rs("field3") 'order of 1 & 2 reversed, in case "field 3" is a
show-stopper somehow
Str1 = rs("field1")
All 3 fields have stuff in them.
Error handling is turned off, so if there were an ASP error, it would
throw it on the screen. All 3 fields in the database are type varchar.
My mind is boggled. Does anybody have even a wild guess as to what
could be going on here?
More information about the thelist
mailing list