Too few parameters

[thesti]

hi,

i have these lines of code (they are jsp)

13:     ResultSet result = statement.executeQuery("select COUNT(id) from message where to='test'");
14:     Integer inbox = result.getInt(0);
 

but then when i execute, i get the following error

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
 

did i do something wrong?

thanks.

[NeoPa]

You posted this question in the Access forum.

Although there is a reference to Access, this is not an Access problem.

I will move it to the JavaScript forum on the understanding this is the code you're using. Let me know if it should really be somewhere else.

[Dormilich]

I will move it to the JavaScript forum on the understanding this is the code you're using. Let me know if it should really be somewhere else.

to me it looks rather like Java. definitely not JavaScript.

[NeoPa]

Thanks Dormilich. I'll try there.