• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
  • paul wheaton
  • Tim Cooke
  • Devaka Cooray
  • Rob Spoor
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Carey Brown
  • Mikalai Zaikin

how to select values for second drop down depending upon value of first drop down

Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi can any one help me.
I am trying to select value for my first drop down from the data base[i.e dynamic drop down which will display all the country names]. Depending upon the value you have selected for the first drop down I would like to show all the related data in the second drop down[i.e. all the states for the selected country].
Here is the code:& lt%@page import="java.sql.*"%>
& lthtml>
& ltbody>
& lt% String state = request.getParameter("state"); out.println(state);%>
& ltform name="my" action="abhay.jsp" method="post">
Country Name:& ltselect value=state onchange="my.submit();">
& lt%
Connection con = null;
Statement st = null;
ResultSet rs = null;
con = DriverManager.getConnection("jdbc:odbc:abhay","root","root");
st = con.createStatement();
String sa="select cname from cname";
rs = st.executeQuery(sa);
String y = rs.getString("cname");
& ltoption value="& lt%= y%>">& lt%= y%>& ltoption>
& lt%
catch(Exception e)
state= request.getParameter("state");
& lt/select>
& lt/form>
& ltform name="m">
& lt%
String h = request.getParameter("state") ;
& lt/form>
& lt/html>
Every time you till, you lose 30% of your organic matter. But this tiny ad is durable:
a bit of art, as a gift, the permaculture playing cards
    Bookmark Topic Watch Topic
  • New Topic