too few parameters expected 1

[ash_log]

Hello,
I am getting the error message Error: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
All column names in SQL command are matching with all in the database.
Still the same error is coming .
The query "select * from user" works fine.But the simple query "select
username from user"
giving me the error.And "username" field exists in table.
Also i m only getting the error while using Microsoft Access .It works fine
with all other database like SQL or Oracle.
Is it a problem with driver?
Please help.

Thanks.

[BKBK]

I immediatedly thought of keywords, but I don't think that's the case here.
Check the spelling and make sure the four words in your Access query are
actually separated by spaces!

[SQLMenace]

Username might be a reserved word in access
try putting brackets around it

[Dan Bracuk]

Does the same thing happen when you run the query in Access directly, ie with
Cold Fusion?

Originally posted by: ash_log
Hello,
I am getting the error message Error: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
All column names in SQL command are matching with all in the database.
Still the same error is coming .
The query "select * from user" works fine.But the simple query "select
username from user"
giving me the error.And "username" field exists in table.
Also i m only getting the error while using Microsoft Access .It works fine
with all other database like SQL or Oracle.
Is it a problem with driver?
Please help.

Thanks.

[ash_log]

Thanks a lot . My problem got solved.It was Actually a version problem.

Thanks,

ash_log :)