Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asptoday_discuss thread: Can't add new record. Please help me. I am going mad


Message #1 by "Richard" <richie_ong@h...> on Sun, 6 Oct 2002 17:20:33
<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

  Return to Index