object property execute method question

[lenin]

Can anybody please tell me what is wrong with the following command? I recieve error message

"ODBC error .... two few parameters provided. Expected 2"

Even though the execute method has only OPTIONAL parameters!

'
' Set activeconnection Execute the command
'
Dim lc_command As New ADODB.Command

lc_command.CommandText = "update cartitem set quantity = quantity + 1 where cart_id = lCartID and widget_id = lItemID"

lc_command.ActiveConnection = lconn
lc_command.CommandType = adCmdText
lc_command.Execute


This is fairly urgent for me, so any response is greatly appreciated.

[Mongo]

The ODBC driver errors with "Too few parameters. Expected n." when you have a misspelled field/table name or you have literal special characters, like the pipe ("|") symbol, processed in the where clause. Which error code are you getting? That would give me more to go on.

[lenin]

Yes mongo, I realised this faux pais about 3 nanoseconds after posting the issue. Thanks for the help anyway.

lenin