[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