pass selected item from combobox to SQL statement used by another combobox
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Rania_Hassan
Posted On:   Sunday, February 13, 2011 03:42 PM

Subscribe to Events how to pass the selected item from evnt_cat combobox to SQL statement used by evnt_subcat combobox? <%! private Connection connect = null; private PreparedStatement pstmnt = null; private String sql; private ResultSet rs; private String sql1; private String cc= ""; String cat_e=""; %> Event Category: --Select Category-- <%=cat_e%>"><%=cat_e%> Event Sub_Category: --Select Subcategory-- <%=cc%>"><%=cc%>    More>>
Subscribe to Events

how to pass the selected item from evnt_cat combobox to SQL statement used by evnt_subcat combobox?









<%!
private Connection connect = null;
private PreparedStatement pstmnt = null;
private String sql;
private ResultSet rs;
private String sql1;
private String cc= "";
String cat_e="";
%>




Event Category:


Event Sub_Category:





   <<Less
Report | Quote This | Send private message | Reply | Print

Re: pass selected item from combobox to SQL statement used by another combobox

Posted By:   Anonymous  
Posted On:   Wednesday, February 16, 2011 06:03 AM

What you could probably do is to have two POST methods.
POST the first item selected (from evnt_cat combobox) and use the value from the bean corresponding to that in the next combobox. you can create an instance of that over there.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact