I have a .jsp page that has a multi checkbox. I'm able to insert the multiple checkbox values but when use an update, it adds the current checkbox rows plus the additional checkbox value rows. If I check one more box it should add 1 more row and so on.
Here is my code that works for inserting data, this works okay:
CollDAO.java
Insert checkbox records
If I select 2 check boxes this is what it looks like.
rID | qID | cID -- CORRECT OUTPUT
101 | 121 | 9
100 | 121 | 13
Here's code for Updating checkbox records, this does not work.
If I select 3 check boxes this is what get updated.
rID | qID | cID -- WRONG OUTPUT
105 | 121 | 2
104 | 121 | 9
103 | 121 | 13
101 | 121 | 9
100 | 121 | 13
This is what it suppose to look like.
rID | qID | cID -- CORRECT OUTPUT
103 | 121 | 2
101 | 121 | 9
100 | 121 | 13
I've been working on this for a week, can you help me?
You need to stick some debugging statements in there to log where in your code you have got to and what the values are.
At the moment you are guessing that it is going into the UPDATE section of your code, but since new lines are being inserted into the database it has to be going into the INSERT part.
Use code tags instead of the quote button, which will make your post look much better. Also line 3 is too long. Since you are new, I have corrected both things for you.
Deon Gee wrote:mmm so should this be and insert and select?
No, what I'm saying is that, for whatever reason (and debugging logs will help here) your code is not going into the updateCol1 method. It is going into the addCol1 method.
To figure out why then you need logs.