HTML Select tag with Multiple selected.?

Question

How can i add a selected values to MySQL database using JSP. I tried to add but it is saving only the first selected values. Can anyone resolve this....

Answer 1

In JSP, as in any other language, you only need to go through the array adding the values to the database. As you mentioned that the problem is that only the first value is being added I assume that the problem is in the HTML code. When using multiple options you must append brackets "[]" at the end of the control's name. e.g.:


This will send the selected options as an array. If you don't use the brackets, the submitted value will be a string containing only the first option.

2006-09-11 13:50:37 · answer #1 · answered by Diegosolo 2 · 0⤊ 0⤋

I'm not familiar with JSP however in Perl this can be achieved by assigning the select element's variable to an array. I think the smart work to achieve this is done with the CGI.pm module. Either that or Perl itself is smart enough to understand the delimeter character(s) the browser has applied to the element to break up values. Sometimes Perl may need a helping hand by using the split function.

So that's the first thing I'd try: assigning the select element's variable to an array in your JSP script. Then naturally you can process it with some sort of loop such as a foreach in Perl.

2006-09-11 08:12:14 · answer #2 · answered by an0n 1 2 · 0⤊ 0⤋

First, you should combine all selected values in a loop together with the seperator " , " , i.e. " 'x','y','z' ". Then your sql should be like " INSERT INTO tbl VALUES (?) ", and then the parameter you send to this query must be the combined values " 'x' ,'y' ,'z' ". You should be careful in the loop, your combined values shouldn't be like " ' x,y,z' ", it's just one record.

Good luck

2006-09-11 08:07:46 · answer #3 · answered by mdy 2 · 0⤊ 0⤋

In javascript the code is as follows. You have to test every option to see if it has been selected.

for (var i = 0; i < form.selectname.options.length; i++) {
if (form.selectname.options[i].selected) {
// Statements to perform if option is selected
...
}
}

2006-09-11 07:58:59 · answer #4 · answered by AnalProgrammer 7 · 0⤊ 0⤋

fedest.com, questions and answers

Answer 2

I'm not familiar with JSP however in Perl this can be achieved by assigning the select element's variable to an array. I think the smart work to achieve this is done with the CGI.pm module. Either that or Perl itself is smart enough to understand the delimeter character(s) the browser has applied to the element to break up values. Sometimes Perl may need a helping hand by using the split function.

So that's the first thing I'd try: assigning the select element's variable to an array in your JSP script. Then naturally you can process it with some sort of loop such as a foreach in Perl.

Answer 3

First, you should combine all selected values in a loop together with the seperator " , " , i.e. " 'x','y','z' ". Then your sql should be like " INSERT INTO tbl VALUES (?) ", and then the parameter you send to this query must be the combined values " 'x' ,'y' ,'z' ". You should be careful in the loop, your combined values shouldn't be like " ' x,y,z' ", it's just one record.

Good luck

Answer 4

In javascript the code is as follows. You have to test every option to see if it has been selected.

for (var i = 0; i < form.selectname.options.length; i++) {
if (form.selectname.options[i].selected) {
// Statements to perform if option is selected
...
}
}