Can I make a dynamic list box from DB results

[mike.a.rea]

I have a JSP page that returns a set of several different values from a
db table. I can show these in tabular format without a problem.

However I was wondering if there was a way that I could use the
information in a drop down list box, maybe use one variable as the Item
Label and another one as the Value.

Any ideas on how I can do this? Thanks in advance.

 

[ducnbyu]

I have a JSP page that returns a set of several different values from a
db table. I can show these in tabular format without a problem.

However I was wondering if there was a way that I could use the
information in a drop down list box, maybe use one variable as the Item
Label and another one as the Value.

Any ideas on how I can do this? Thanks in advance.

Try:

<html:select property="selectField">
<htmlption value="-- Select One --"/>
<htmlptionsCollection property="table" label="name" value="code" />
</html:select>

In your form (java) class you probably already have a collection that
you use to display the table. In my example (note the capitalization),
the class in the collection would have getName() and getCode() methods.

 

[Oliver Wong]

I have a JSP page that returns a set of several different values from a
db table. I can show these in tabular format without a problem.

However I was wondering if there was a way that I could use the
information in a drop down list box, maybe use one variable as the Item
Label and another one as the Value.

Any ideas on how I can do this? Thanks in advance.

If you know how to do this in a tabular format, presumably, you have code
which emits something like:

<table>
<tr><td>VALUE A</td></tr>
<tr><td>VALUE B</td></tr>
</table>

So change your code so that it instead outputs:

<select>
<option>VALUE A</option>
<option>VALUE B</option>
</select>

As for the issue of using a label versus a value, the value attribute has no
equivalent in a table, so I'm not sure what you intend to do there.

- Oliver

 

[mike.a.rea]

Ok thanks, this is the road I was going down, just haven't got it to
work yet.
No there is no equivalent the the Value attribute in the table.
However I have several different data fields being returned from the
data table for each record, I just want to show one field to the end
user and pull another to pass along to the next application.
Thanks again, I will keep working on it.

 

[mike.a.rea]

Ok thanks, this is the road I was going down, just haven't got it to
work yet.
No there is no equivalent the the Value attribute in the table.
However I have several different data fields being returned from the
data table for each record, I just want to show one field to the end
user and pull another to pass along to the next application.
Thanks again, I will keep working on it.

 

[Lew]

Try:

<html:select property="selectField">
<htmlption value="-- Select One --"/>
<htmlptionsCollection property="table" label="name" value="code" />
</html:select>

In your form (java) class you probably already have a collection that
you use to display the table. In my example (note the capitalization),
the class in the collection would have getName() and getCode() methods.

The OP did not state that he was using Struts. For these constructs I would
prefer JSTL (e.g., <c:forEach>)even if I were using Struts.

- Lew