Current Recordset does not support updating.

[chrisawilliams]

I am trying to compare a record (active) field. If the field is no then send the user to a not active page and if it is yes, send the user to the main page. This is what I have so far:

<!--#include file="inc/requestcookies. asp"-->
<!--#include file="inc/common.inc"-->
<%
strSQL = "SELECT * FROM memberslist WHERE username = '" & username & "'"
Set rst = conn.Execute(st rSQL)

Dim myaccount
Rst("active") = myaccount

If myaccount = "no" then
response.redire ct = "notyetactivate d.asp"
else
response.redire ct ="main_page.asp "
end if

Please help!!!!!!

[viktorka]

I think it should be myaccount = Rst.fields("act ive")

What happened if there is no such record?