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

[MAS]

Hi All,

I have a problem..when i want to execute this code

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:StudentMana gement");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select stuID from marking where lectName="+lctName);
if (rs.next()) {
ID.addItem(rs.getString(1));
}
rs.close();
} catch(Exception ex1) {
ex1.printStackTrace();;
}

i'm getting this error
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7113)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :3109)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt atement.java:337)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO dbcStatement.java:252

All column names in SQL command are matching with all in the database.

[Tolls]

Your SQL is wrong, unless lectName is a NUMBER field.

[MAS]

thank you
i have solve the problem
i am using like statement