0

In Java DAO object following statement works:

String sqlDelete =  "delete from table where id = ?";  //Argument is 1

This deletes exactly one row.

However, when I change it to:

"delete from table where id in (?)";//Argument is 1,2

0 rows deleted. No errors, no exceptions. When I run the statement in SQL, it works correctly.

Any ideas why equals operator works, but in operator doesn't?

Mark Rotteveel
  • 90,369
  • 161
  • 124
  • 175

0 Answers0