checkboxes from qyery ? how to 2005-09-18 - By kamal adif
Back
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 listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(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
|
|
