Is objRS.Fields("fieldname") cached?

[yesti]

I have MySQL 3.23.53-max-nt, MyODBC 2.50.39 running on win2k server sp2 and iis 5.0. The VBScript below works on MS Sql server, but sets the 'approved' column to 'no' for all rows on MySQL. Any ideas? Thanks.

While CInt(ctr)<CInt(Request.Form(&quot;ctr&quot)
linid=CInt(Request.Form(&quot;LineID&quot;&ctr))
strSQL=&quot;SELECT Approved FROM PORequest WHERE RecordID=&quot;&recid&&quot; And LineID='&quot;&linid&&quot;'&quot;
objRS.Open strSQL,objConn,1,2
If objRS(&quot;Approved&quot<>&quot;pending&quot; Then Response.Redirect &quot;../logout.asp?s=13&quot;
If Request.Form(&quot;approved&quot;&ctr)=&quot;yes&quot; Then
objRS.Fields(&quot;Approved&quot=&quot;yes&quot;
Else
If Request.Form(&quot;approved&quot;&ctr)=&quot;no&quot; Then
objRS.Fields(&quot;Approved&quot=&quot;no&quot;
End If
End If
objRS.Update
ctr=ctr+1
Wend