By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

(0x80040E10) Too few parameters. Expected 1.

P: 2
I'm quite new to asp/sql and would appricicate some help..
I'm trying to update AmountInStock in the appropriate record, by IDKEY..

ERROR:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

CODE:

IDKEY=CStr(Request.querystring("IDKEY"))

sql="UPDATE acc SET AmountInStock = AmountInStock-1 WHERE IDKEY = '"&IDKEY&"' "
objConn.Execute(sql)
Apr 27 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
I'm quite new to asp/sql and would appricicate some help..
I'm trying to update AmountInStock in the appropriate record, by IDKEY..

ERROR:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

CODE:

IDKEY=CStr(Request.querystring("IDKEY"))

sql="UPDATE acc SET AmountInStock = AmountInStock-1 WHERE IDKEY = '"&IDKEY&"' "
objConn.Execute(sql)
Hi,

One question? What is the retrieved value of IDKEY after IDKEY=CStr(Request.querystring("IDKEY"))?

And may be if you put ; at the and of your SQL???

Have a nice luck!

:)
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.