Problem using Java and Microsoft Access

[AlistairMonkeyFinger]

Hi,

i have a small appliction that talks to a Access database. I can create the connection fine and issue queries no problem. The problem i am having is with a field containing a space. So i have a query..

select * from [List prices] where [Catalogue No] = "100013"

which runs fine in access, but when i run it from

Statement s = conn.createStatement();
String SQL = "select * from [List prices]  where [Catalogue No] = \"100013\""
s.execute(SQL);

i get an error

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

Any ideas ?

Alistair

 

[AlistairMonkeyFinger]

Ok, found the answer, stupid really...

String SQL = "select * from [List prices]  where [Catalogue No] = '100013'"

Alistair