Posted By:
Anonymous
Posted On:
Sunday, May 11, 2003 11:50 PM
Hi Code,
I think that you may be getting an error as you are trying to read the same column twice( Line A and Line B in the following code).
<% cpartner.connect();
ResultSet rsPartner = cpartner.getPartner();
ResultSet rsPartnerCategories = cpartner.getPartnerCategories();
while (rsPartnerCategories.next()) { %>
<%= rsPartnerCategories.getString("PartnerCategoryName") %> // line A
<% while (rsPartner.next()) { %>
<%= rsPartnerCategories.getString("PartnerCategoryName") %> // line B
<%= rsPartner.getString("PartnerCategoryName") %>
<%= rsPartner.getString("PartnerName") %
Here is the reason(from the ResulSet API):
ResultSet columns within each row should be read in left-to-right order, and
each column should be read only once. Removing Line A or Line B should fix your problem.
Please use 'pre' tags for the code you put in the page. This would make your code readable(formatted).
