• Post Reply Bookmark Topic Watch Topic
  • New Topic

Jsp/MySql problem

 
mrsmithq
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Works fine when lines are commented out but not when they are uncommented. When they are not commented out it only goes through links.next() loop like there is only one entry in the ResultSet for links.

<%@ taglib uri='/WEB-INF/templates/jsp/tld/template.tld' prefix='jetspeed' %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="corpadmin" class="org.beans.LeftMenuBean"/>
</jsp:useBean>

<%
ResultSet menu = corpadmin.get_menu_Query();
while (menu.next())
{
String temp = menu.getString("MENU_NAME");
String temp2, temp4="", temp3;
ResultSet links = corpadmin.get_links_Query(temp);
while (links.next())
{
temp4 = links.getString("URL");
System.err.println(temp4);
if (request.getParameter(temp4)!=null)
{
corpadmin.Select_Link(temp, temp4, 'Y');

}
else
{
corpadmin.Select_Link(temp, temp4, 'N');
}
}
}
%>
<jsp:forward page="jetspeed/screen/Home"/>
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!