Combo Box using JSP

chmanio · Nov 25, 2004

im querying a database and i want to store the results in a combo box. im using the following code :

<select>
<option><%
while (rs1.next()) {
out.println(rs1.getString(1));
}
%>
</option>
</select>

my problem is the data stored in the combo box are concatenated in a single row.

example : value1 value2 value3 value4 value5

i want the result to be:

value1
value2
value3
value4
value5

pls help!

thanks!

prosper · Nov 25, 2004

Code:

<%! String myChoice[] = {"zero","one","two","three"};
%>
<html>
<head>
</head>
<body>
<form name="f1">
<select name="s1">
<% for(int i=0; i<myChoice.length; i++) {%>
<option value="<%=i%>"><%=myChoice[i]%></option>
<% }%>
</select>
</form>
</body>
</html>

prosper · Nov 25, 2004

Code:

<%!
    // get all string before output html
    // this is not complete code
    int MAXREC = 20;
    int count=-1;
    String myChoiceB[] = new String[MAXREC];
%>
<%
  while (rs1.next()) {    
    count++;
    if (count>MAXREC-1)
       break;
    myChoiceB[count]=rs1.getString(1);
  } 
%>
<html>
<head>
</head>
<body>
<form name="f1">
<select name="s1">
<% for(int i=0; i<=count; i++) {%>
<option value="<%=i%>"><%=myChoiceB[i]%></option>
<% }%>
</select>
</form>
<%=count%>
</body>
</html>
</form>
</body>
</html>

prosper · Nov 25, 2004

Code:

// fix logical bug
<%
  while (rs1.next()) {    
    count++;
    if (count>MAXREC-1)
       {
        count = MAXREC-1;
        break;
       }
    myChoiceB[count]=rs1.getString(1);
  } 
%>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Combo Box using JSP

chmanio

Programmer

prosper

Programmer

prosper

Programmer

prosper

Programmer

Similar threads

Part and Inventory Search

Sponsor