Recordset Updating

Discussion in 'Databases' started by mother, Nov 7, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Found nada with the search so here I go. My coding works locally on my server but receive below error on DASP. Basically I am getting a Auto number for there order via one recordsetand then save contents of Cart to DB via a diifferent table in same DB all done with one form and Button.

    ERROR.

    ADODB.Recordset error '800a0cb3'


    Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
     
  2. Someone throw me a bone. Here is some code where I think the problem is happening.






    <%
    '
    'Insert record into Orders recordset when form is submitted
    'and store the unique OrderID
    '
    CC_OrderAction=Request.ServerVariables("SCRIPT_NAME")
    if Request("CC_OrderInsert") <> "" then
    TimeKey=GetTimeInMillisec()
    OrdersRS.AddNew
    OrdersRS("TimeKey")=TimeKey
    For Each fld in OrdersRS.Fields
    if Len(Request(fld.Name)) > 0 then
    fld.Value = Request(fld.Name)
    end if
    Next
    OrdersRS.Update
    OrdersRS.Requery
    OrdersRS.Filter= "TimeKey='" &amp; TimeKey &amp; "'"
    Session("OrderID")=OrdersRS("OrderID")
    end if
    %>
     
  3. I will give it a try. Thanks
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page