Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ODBC - too few parameters ??

 
Julie de Wet
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is probably a trivial problem - but I'm stuck
SELECT MA-nr, Fornavn FROM Medarbejder WHERE MA-nr = '0200695';
I make a PreparedStatement with the above sql, when I call executeQuery I get the following exception:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access-driver] Der er for f� parametre. Der var ventet 2
i.e. too few parameters - 2 were expected.
What could be possible/probable causes ?
 
Julie de Wet
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It was trivial. It was the hyphon.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic