Go4Expert

Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   2 comboboxes values of 2nd depends on 1st ,OPTION values from Database (http://www.go4expert.com/forums/2-comboboxes-values-2nd-depends-1st-t17961/)

sriram225 12Jun2009 16:23

2 comboboxes values of 2nd depends on 1st ,OPTION values from Database
 
hi all!
i am new to jsp, i have two comboboxes,in which values of 2nd combo box are linked two first combo box and we get values for both these boxes from database.

table1
Code:

(pk)itemno:text
itemname:text (no duplicates)

table2
Code:

(pk)itemno:text(duplicates)
(pk)pcode:text
pname:text(no duplicates)

i want to display..

combobox1:itemname
combobox2:pname

Note: Both Values of combobox are to be retrieved from database.

when user select itemname corresponding values of pname should be displayed. I went through google and some threads of this forum and found some info but there option values are not retrieved from database(given in code itself), but i'm puzzled from retrieving 1st combo values and select one to retrieve the values of 2nd combo.

Hope i have made my question clear. Thank You all!


All times are GMT +5.5. The time now is 22:03.