F
frawls
Hi,
I am having problems populating a dropdown list in a jsp page with
mulitple entries from a database. Can anyone please help me with the
code or point me in the right direction. Im am using the oreily custom
tags. The page is as follows.
<%@ page language="java" contentType="text/html" %>
<%@ page import="java.util.*" %>
<%@ page import="com.ora.jsp.util.*" %>
<%@ taglib uri="/orataglib" prefix="ora" %>
<HTML>
<BODY>
<ora:sqlQuery id="sqlAdminDropdown" dataSource="AileenDB"
scope="session">
SELECT AdminName From Aministrator
</ora:sqlQuery>
<TABLE>
<TR>
<TD>
** Need to put the dropdown populated with ALL the
AdminName here **
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
I have tried things like the following but dont have a clue:
<html:select name="session">
<htmlptionsCollection name="sqlAdminDropdown"
property="sqlAdminDropdown" labelProperty="AdminName"/>
</html:select>
I am having problems populating a dropdown list in a jsp page with
mulitple entries from a database. Can anyone please help me with the
code or point me in the right direction. Im am using the oreily custom
tags. The page is as follows.
<%@ page language="java" contentType="text/html" %>
<%@ page import="java.util.*" %>
<%@ page import="com.ora.jsp.util.*" %>
<%@ taglib uri="/orataglib" prefix="ora" %>
<HTML>
<BODY>
<ora:sqlQuery id="sqlAdminDropdown" dataSource="AileenDB"
scope="session">
SELECT AdminName From Aministrator
</ora:sqlQuery>
<TABLE>
<TR>
<TD>
** Need to put the dropdown populated with ALL the
AdminName here **
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
I have tried things like the following but dont have a clue:
<html:select name="session">
<htmlptionsCollection name="sqlAdminDropdown"
property="sqlAdminDropdown" labelProperty="AdminName"/>
</html:select>