-
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.
-
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.
-
Yes mongo, I realised this faux pais about 3 nanoseconds after posting the issue. Thanks for the help anyway.
lenin
