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
  • 100,966
  • 191
  • 140
  • 197

0 Answers0