I'm using HTML in a .jsp and Java in a servlet to process the jsp.
I have a form for Skills, with 12 checkbox options to choose from.
Obviously more than one can be selected, and I want these then sent to a database. (As an example, Adam can have Java and C++ and Bob just has Java).
I want only one field in my database to contain the information for all of the checkboxes. At the moment, I have the skills going in as one string with " " separating them, but then when I try to retrieve the info, I don't get the right info back.
For example, if I search for any employee with "Java" I get back Bob's details but not Adam's, because it's part of a string "Java C++" instead of being separate.
Do you have any suggestions on how to have multiple checkbox options stored into a single field in a database, but can