I am using pager taglib from www.jsptags.com. I get
data from a database fine when I get ALL the data.
However when a user enters info from a form to be used
in SQL clause, the data comes up on the first page (of
1/2/3/4/5... etc) but when you go to the next page,
the values are null. Included is some sample code and
the error 500 that I get. Please Help!!!!
Thanks
Dan
Sample Code============================
<%@ taglib uri="http://someurl.net" prefix="pg" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page session= "true" %>
<!-- //Prepare session variables with initiall null
values -->
<%! String field=""; %>
<% //Get the fields passed from Search request page
from form submission
field = request.getParameter("fieldname");
session.putValue("fieldname", field);
%>
<% //Get the fields passed from session values
String field = (String) session.getValue("fieldname");
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection myConn =
DriverManager.getConnection("jdbc:odbc:test_db");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("SELECT "
+field+ " FROM tbl_test");
%>
<%
String requestUri = request.getRequestURI();
int indexOfqm = requestUri.indexOf('?');
if (indexOfqm != -1)
requestUri = requestUri.substring(0, indexOfqm);
String style = request.getParameter("style");
%>
<body bgcolor="#FFFFFF" topmargin="0">
<pg:pager maxIndexPages="<%= 10 %>" maxPageItems="<%=
10 %>">
<pg:param name="style"/> <% /* keep track of style
*/ %>
<table border="0" cellspacing="2" cellpadding="0"
width="46%" align="center">
<tr bgcolor="lightgrey">
<td width="341" height="7" bgcolor="#663300">
<div align="center"><font face="Arial,
Helvetica, sans-serif" size="2">
<b><font color="#FFFFFF">Search
Results</font></b></font> </div>
</tr>
<%
if (myResultSet != null) {
while (myResultSet.next()) {
String a = myResultSet.getString(1);
%>
<pg:item>
<tr bgcolor="lightgrey">
<td width="341" height="8">
<div align="left"><font face="Arial, Helvetica,
sans-serif" size="2"><%= a %>
</font> </div>
</tr>
</pg:item>
<%
}
}
stmt.close();
myConn.close();
%>
</table>
<br>
<br>
<center>
<pg:index>
<pg:prev>
<a href="<%= pageUrl %>">[ (<%= pageNumber %>) <<
Previous ]</a>
</pg:prev>
<pg:pages>
<a href="<%= pageUrl %>"><%= pageNumber %></a>
</pg:pages>
<pg:next>
<a href="<%= pageUrl %>">[ Next >> (<%=
pageNumber %>) ]</a>
</pg:next>
</pg:index>
</pg:pager>
</center>
ERROR===========================================
null
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at
allaire.jrun.session.JRunSession.setAttribute(JRunSession.java:240)
at
allaire.jrun.session.JRunSession.putValue(JRunSession.java:226)
at
jrun__test__po_srch_result2ejsp18._jspService(jrun__test__po_srch_result2ejsp18.java:46)
at
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:40)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at
allaire.jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:34)
at
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:175)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:88)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1131)
at
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:330)
at
allaire.jrun.http.WebEndpoint.run(WebEndpoint.java:107)
at allaire.jrun.ThreadPool.run(ThreadPool.java:272)
at
allaire.jrun.WorkerThread.run(WorkerThread.java:75)
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
===========================================================================
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