i want to delete single/multiple rows from database table on clicking the checkbox, in addition it should first show all the rows and columns.
A part of code i am using is:
Problem with the code is, when i remove 'value="<%= rs.getString("bookid")' in input type, only then it shows whole data (select*from book)
and it deletes a row, bt as data is not shown, we cant predict which row is about to delete.
Also in case of deletion of multiple rows,
i am getting syntax error as==> Syntax error (missing operator) in query expression 'bookid IN()'.
Can somebody help me ??