capturing value of drop-down box

[mallz]

hi,
i am getting the values for the drop-down box from the database. On selection of an option and on the click of a button it does unique actions for each option.
But, i am unable to capture the value of the option, since i am retrieving from database it displays the options in same order always..
please help....

[r035198x]

hi,
i am getting the values for the drop-down box from the database. On selection of an option and on the click of a button it does unique actions for each option.
But, i am unable to capture the value of the option, since i am retrieving from database it displays the options in same order always..
please help....

Where are you not able to capture the value of the option. Can you explain the problem a bit more?

[mallz]

Where are you not able to capture the value of the option. Can you explain the problem a bit more?

in the second form on which i retrieve the values from the database again for display in the combo box, but this time, i want what i have selected in form1 to be displayed in the combobox

[r035198x]

in the second form on which i retrieve the values from the database again for display in the combo box, but this time, i want what i have selected in form1 to be displayed in the combobox

Post the codes you have used for the combo and for retrieving the value.

[mallz]

Post the codes you have used for the combo and for retrieving the value.

Form1:

Filter by Status: <select name="stat" >

 <%! 
        Connection con=null;
        Statement st=null;
        ResultSet rs=null;    
%>
 

[HTML] <%
String statusname=null;
try
{
con=DbUtil.getConnection();
st=con.createStatement();

try
{
String query="select * from status";
rs=st.executeQuery(query);
}
catch(Exception e)
{
System.out.println(e);
}
while(rs.next())
{
statusname=rs.getString("statusname");
//System.out.println(statusname);
%>
<option value=<%=statusname%>><%=statusname%></option>
<%
}
con.commit();
}
catch(Exception e1)
{
System.out.println(e1);
}
finally
{
rs.close();
st.close();
}
%>

</select>
<input type=submit value="Go!" onFocus = "statvalidation(this.form)">
[/HTML]
in form1 i am retrieving these values from database, the options being a,b,c,d

Form2:

in form 2 i have the same code repeated, but if he selects 'c' in form1, and clicks button go, the dropdown box in form2 should have 'c' as its selected option, but by default it is showing as 'a', as i am retrieving from database....

[r035198x]

Form1:

Filter by Status: <select name="stat" >
<%!
Connection con=null;
Statement st=null;
ResultSet rs=null;
%>


<%
String statusname=null;
try
{
con=DbUtil.getConnection();
st=con.createStatement();

try
{
String query="select * from status";
rs=st.executeQuery(query);
}
catch(Exception e)
{
System.out.println(e);
}
while(rs.next())
{
statusname=rs.getString("statusname");
//System.out.println(statusname);
%>
<option value=<%=statusname%>><%=statusname%></option>
<%
}
con.commit();
}
catch(Exception e1)
{
System.out.println(e1);
}
finally
{
rs.close();
st.close();
}
%>

</select>
<input type=submit value="Go!" onFocus = "statvalidation(this.form)">

in form1 i am retrieving these values from database, the options being a,b,c,d

Form2:

in form 2 i have the same code repeated, but if he selects 'c' in form1, and clicks button go, the dropdown box in form2 should have 'c' as its selected option, but by default it is showing as 'a', as i am retrieving from database....

Please always use code tags when posting code.

Where is form1 submitting to? If it is submitting to form 2 then pass then retrieve the selected value in form2 and then use an if else for displaying the options

 if(valueFromDatabase.equals(valueFromForm1)) { 
%>
<OPTION value="<%=valueFromDatabase%>" selected > <%=valueFromDatabase%></OPTION>
<%
} 
else {
%>
<OPTION value="<%=valueFromDatabase%>" > <%=valueFromDatabase%></OPTION>
<%
}
%>
 

[mallz]

Please always use code tags when posting code.

Where is form1 submitting to? If it is submitting to form 2 then pass then retrieve the selected value in form2 and then use an if else for displaying the options

 if(valueFromDatabase.equals(valueFromForm1)) { 
%>
<OPTION value="<%=valueFromDatabase%>" selected > <%=valueFromDatabase%></OPTION>
<%
} 
else {
%>
<OPTION value="<%=valueFromDatabase%>" > <%=valueFromDatabase%></OPTION>
<%
}
%>
 

Thanks a lot, the piece of code you posted solved the problem