Let me provide my code below, maybe that will help (sorry for wasting the sheriff's time). Note the below works except that the inner loop only displays the members list (column for each task listed in outer loop) for the first task, the remaining tasks (outer loop) show a blank select list for members from then on.
snippet from class that gets data:
----------------------------------
stmt = myConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
query="select nbid, first_name from tbl_amis_members order by last_name";
rs = stmt.executeQuery(query);
rslt = ResultSupport.toResult(rs);
rs.close();
stmt.close();
return rslt;
snippet from the servlet that acts as traffic controller:
---------------------------------------------------------
request.setAttribute("amisMembers", amembers.findMembers());
address = "[jsp-file-listed-below]";
RequestDispatcher dispatcher = request.getRequestDispatcher(address);
dispatcher.forward(request, response);
snippet from
JSP page where results are displayed:
---------------------------------------------------
<c:forEach var="amisTasks" begin="0" items="${amisTasks.rows}" varStatus="counter">
<tr>
<form name="amis_tasks_update" method="post" action="/amis/AmisController">
<td><c:out value="${amisTasks.id}"/>
<input type="submit" value="update" />
<td><c:out value="${amisTasks.description}"/></td>
<select name="task_owner" >
<option value="${amisTasks.nbid}">
<c:out value="${amisTasks.first_name}"/></option>
HERE BELOW is the inner loop that only gets displayed the first time around
<c:forEach var="amisMembers" begin="0" items="${amisMembers.rows}" varStatus="counter2">
<option value="${amisMembers.nbid}">
<c:out value="${amisMembers.first_name}"/></option>
</c:forEach>
</select>
</td>
</form>
</tr>
</c:forEach>
Thanks for any help anyone can provide.