annnkay
|
Posted: 02/04/2002, 10:49 AM |
|
i've been working on a search engine.by following the example in the bookstore application... but i keep having this error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.what went wrong...
|
|
|
annnkay
|
Posted: 02/04/2002, 10:56 AM |
|
and also this kind of error - java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. and i forgot to inform that i'm using the jsp.
|
|
|
Nicole
|
Posted: 02/05/2002, 1:59 AM |
|
Hello,
1. If you use a DSN connection you cannot use double double quotes (""any_val"") inside custom sql or custom code. Check it and try to replace them with single quotes ('any_val')
2. the error reason is described in error message, so check sql query.
|
|
|
|