"No data found" error for Resultset
843838May 18 2006 — edited May 21 2006Hi all,
I am using Tomcat 4.1 and MS Access as the database.
<SCRIPT language=JavaScript>
<!--
function go(loc)
{
window.location.href = loc;
}
</SCRIPT>
<HTML>
.
.
<TR onclick="go('checkitem.shtml?make=<%out.print(rs.getString(1));%>');">
.
.
</HTML>
when i write the code above (rs.getString(1)) then i get the desired result. but if i use rs.getString(2) instead of rs.getString(1) then i get the following error:
exception
org.apache.jasper.JasperException: No data found
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service
root cause
javax.servlet.ServletException: No data found
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533)
at org.apache.jsp.inbox_jsp._jspService(inbox_jsp.java:287)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
Please help me out.
Thanks i advance.
Regards,
Amol