Recordset Updating

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.

 

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
%>

 

Hi,
I'd do some in-line debugging to find out wha the passing values are.
For example, find something that will crash with the error, then...
Do the same thing but update that code section to return values to your page.
i.e. <%= TimeKey %>
Salute,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)

 

I will give it a try. Thanks