[thelist] ASP RecordSet weirdness

[Tab Alleman]

Anthony Baratta wrote:
> What happens when you Trim() the RecordSet Data? I do know there is a
> bug in ADO that prevents you from grabbing data from the row after
> you have grabbed a Text Column.

Assuming you mean what if I do this:  

Str1 = Trim(rs("field1"))
Str3 = Trim(rs("field3"))   	
Str2 = Trim(rs("field2"))

...no difference in behaviour.

I also tried:  

Str3 = Trim(rs("field3"))   	
Str1 = Trim(rs("field1"))
Str2 = Trim(rs("field2"))

...again, fields 1 & 3 are fine, field2 is unexpectedly empty.  So it
seems if I pull data from field2 after pulling from field3, field2's
data is missing, even if I interpose other calls to the recordset
between them.

Any other wild guesses?