JSP and Stored procedures
<p>I have a JSP page that has two select dropdown menus. Each of the dropdowns is populated from a database using a stored procedure.  One drop down has a name to search and other has an orderno kind of search. selecting either one of that will lead us to next page based on the value of the selected option via pressing a single button.  Right now, I have one select option running successfully. When i tried to introduced the second one, everything got messed up. The page that is getting called has a getparameter call to the select dropdown.</p>

<p>Can any body help me how to incorporate both the select and based on either one of them calls the same page using a button
Here is code..</p>

<p></p>

<pre><code>            Search:&lt;INPUT type="text"  name="edSeachInput" &gt;
            Issuer Name:
                    &lt;select name="IMNT" size='10'&gt;
                    &lt;%
                        String sql1 = ("EXEC store_proc_1");
                        ResultSet rs1 = db.runQuery(sql1);
                        while (rs1.next())
                        {
                    %&gt;
                    &lt;option value="&lt;%= rs1.getString("id_imnt") %&gt;"&gt;&lt;%= rs1.getString("nm_imnt") %&gt;&lt;/option&gt;
                    &lt;%
                        }
                        rs1.close();
                    %&gt;
                    &lt;/select&gt;


            OR

            Search ISIN:&lt;input type="text" name="ISINSearchInput" &gt;

                    &lt;select name="ISIN" size='10'&gt;
                    &lt;%
                        String sql2 = ("EXEC store_proc_2");
                        ResultSet rs2 = db.runQuery(sql1);
                        while (rs2.next())
                        {
                    %&gt;
                    &lt;option value="&lt;%= rs2.getString("id_imnt_") %&gt;"&gt;&lt;%= rs2.getString("order_no") %&gt;&lt;/option&gt;
                    &lt;%
                        }
                        rs2.close();
                    %&gt;
                    &lt;/select&gt;

                &lt;input  type="submit" style= " color:#FFFFFF"  name="drill" class="over" value="Query"  OnMouseOver="rollbg('roll', 'drill')" OnMouseOut="rollbg('over', 'drill')"/&gt;

form&gt;     
</code></pre>
