Forums

This topic is locked

Please help with Access Error!

Posted 31 Oct 2002 22:22:42
1
has voted
31 Oct 2002 22:22:42 Shane Huston posted:
here is my code:
--
'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()
rsOrders.AddNew
rsOrders("OrderTime"=TimeKey
For Each fld in rsOrders.Fields
if Len(Request(fld.Name)) > 0 then
fld.Value = Request(fld.Name)
end if
--
here is my error:
--
ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation.
--
The line that it refers to with this error is the line of code (above) that reads: "rsOrders.AddNew"

please help!!! THanks!

Reply to this topic