This is very simple if you have table REGION(id_region, region_name) and table COUNTRY(id_country, id_region, country_name) then you can use value of first listbox to do select in second listbox like: SELECT country_name FROM COUNTRY WHERE id_region = :id_reg and then that ResultSet you can use to populate your CountryListBox.
Hope this is helpfull. On 3/28/06, Nenad Bosanac <[EMAIL PROTECTED]> wrote: > > Hi everyone! > I had one problem with listbox. > > I had create a page with three listbox in which i had > data from database. > That works fine ,but now i want to put one more > listbox in which will be date from database but only > when someone click on second listbox. > > For example > > in second list box are the values: > Asia > Africa > Europa > > i'd like when someone click on Asia in fourth listbox > to have all > coutries from Asia like this > Japan > China > Iran > > and then when he wants to submit those data to proceed > to database > both Asia like one data ,and choosed coutry Japan for > example. > > How can i do this? If anyone have example or link for > such a thing that will be fine? > I saw on this JSP forum ,but nothing similar exist. > Thanks > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > =========================================================================== > 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 > -- Aleksandar Stoisavljevic [EMAIL PROTECTED] =========================================================================== 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
