[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

liy@ -> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. (6/9/2004 5:27:52)

Hello,

I am getting the error below when I try to search through a database using a drop down list. Here is the error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

Please HELP!!

Thanks. ~Liy@~



Bmastvac -> RE: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. (6/9/2004 5:56:22)

Hi

Liy And welcome to outfront.

Your SQL statement expects 2 values. and your not passing these values to the statement from your drop down list and or form. Common problems wrong name or spelling of drop down. If you post your SQL code we will help.

Bill



liy@ -> RE: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. (6/9/2004 8:02:50)

Thanks for the help, I have solved the problem.[:D]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.125