What is the field type of "loggedon"? If its a field type char it should work. If its a boolean field use:

RS("loggedon") = true



>i am using this code to control how many time a user can log onto a database
>but the first part will not work and i cannot figure out why. any idea would be greatly welcomed.
>cheers
>~M
>
>This is the error i get form explorer
>ADODB.Recordset (0x800A0CB3)
>Object or provider is not capable of performing requested operation.
>
>
>This does not work
>
>Do Until RS.EOF OR foundIt
> If username = RS("username") Then
> If RS("loggedon") = "1" Then
> RS.Close
> Set RS = Nothing
> objConn.Close
> Set objConn = Nothing
> response.redirect("default.asp?error=4")
> Else
>******* LINE IN ERROR: RS("loggedon") = "1"
> RS.update
> End If
>
> foundIt=True
> Else
> RS.MoveNext
> End If
>Loop
>
>
>This does
>Do Until loobjRS.EOF OR foundlo
> If sessionname = loobjRS("username") Then
> loobjRS("loggedon") = "0"
> loobjRS.update
>
> foundlo=True
> Else
> loobjRS.MoveNext
> End If
>Loop