[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