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!