asptoday_discuss thread: Can't add new record. Please help me. I am going mad
<Below is the error>
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of
the provider, or of the selected locktype.
/SE/AddUser.asp, line 16
<Line 16 is at rsUsers.AddNew>
<%
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.CursorType = 1
rsUsers.LockType = 3
rsUsers.Open "Person", objConn
If Session("PersonID") <> "" Then ' currently
logged-on user
rsUsers.Filter = "PersonID = '" & Session("PersonID") & "'"
Else '
New session
rsUsers.Filter = "EMailAddress = '" & Request.Form("email") & "'" & _
"AND Password = '" & Request.Form("password") & "'"
If rsUsers.EOF Then ' User
not found
rsUsers.AddNew
Can someone please help me