Hi,
I'm trying to use JSP resultset.next() multiple times to print HTML tables. However, it doesn't seem to want to work. I can print one or the other fine, but not both. I'm trying something below:
Resultset rs = null;
String SQL = "select column1, column2 from table";
rs = stmtPROD.executeQuery(SQL);
out.println("<table>")
while(rs.next()) {
out.println("<tr><td> " + rs.getString("column1") + "</td></tr>");
out.println("</table><table>");
while(rs.next()) {
out.println("<tr><td> " + rs.getString("column2") + "</td></tr>");
out.println("</table>");
Any tips would be helpful. Thanks!