> I�m a newbie and struggle with the following problem:
> I want the RestultSet to write out every database record,
> between two horizontal lines, but it doest not work. I have a
> method, that converts everything to HTML, and I want a for
> loop, to perform this method on every Record in the table. I
> tried with rs.getArray() and with array.length I tried to
> invoke the methode on every record.
Othmar,
I sounds like you're just wanting to print all the results in the
resultset. Try this:
rs.beforeFirst();
while(rs.next()) {
out.println("<p>The value is " + rs.getString("column1")
+ ".</p>");
}
The rs.beforeFirst() is optional if this is your first traversal through
the resultset.
- James
==========================================================================To
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
