[thelist] ASP RecordSet weirdness

Tab Alleman Tab.Alleman at MetroGuide.com
Thu Apr 1 15:33:21 CST 2004


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