I am trying to do this : when a user login he will be presented with a form that has his skills (he already submited in this form), now he can change his skilles by checking or unchecking the checkboxes and when submit all are saved in a table in a database.
table : user_table (userID, username). table : const_skills (skilID , value). table : lookup_skills (lkupID, userID, skilID). My problem here is how to populate checked and unchecked checkboxes from database. Problem 1 :: Let say a user login for the first time (now we have his userID in a session), then he has a form that lists : Please check your skills : checkbox1 JSP checkbox2 JAVA checkbox3 HTML the when he submit the form, only the skills with checkboxes he checked are inserted in the lookup_skills table. My question here is how to construct the checkboxes in the form using the query : select * from const_skills ? in an other word : <input type="checkbox" value= the first skilID from the query, how to test the checked if it's false or true, /> <input type="checkbox" value= the 2nd skilID from the query, how to test the checked if it's false or true, /> .... Problem 2 :: Next time the user will login he will see in the form all the skills and his skills are checkec. Please help me. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
