James,
Here is my current (sample) code I am working with. I
Now do not get a null pointer exception. But now the
first page with the first 10 rows from query come up.
Then when I go to next pages, the counter is there but
no data. Not even rows with null values.
Any ideas would be helpful.
This little thing is causing such a headache!
Thanks for all the help.
========SAMPLE
CODE====================================
<%@ taglib uri="http://someurl.net" prefix="pg" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page session= "true" %>
<html>
<header>
<style type="text/css">
A.nodec { text-decoration: none; }
<!--
A:link {text-decoration: none;}
A:visited {text-decoration: none;}
A:hover {text-decoration: underline;}
-->
</style>
</header>
<% //Get the fields passed from Search request page
from form submission
String field = request.getParameter("fieldname");
String field2 = request.getParameter("fieldname2");
String equal = request.getParameter("equals");
String sqlstmts = request.getParameter("sqlstmt");
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection myConn =
DriverManager.getConnection("jdbc:odbc:cpedb");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("SELECT
"+field+" FROM tbl_cpetest"+
" WHERE " +field2+ "='"
+sqlstmts+ "'");
%>
<%
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 and
variables */ %>
<pg:param name="field"/> <% /* keep track of variables
*/ %>
<pg:param name="field2"/> <% /* keep track of
variables */ %>
<pg:param name="sqlstmts"/> <% /* keep track of
variables */ %>
<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>
</body>
</html>
--- James Klicman <> wrote:
> Hi Dan,
>
> First you should make sure field != null before
> trying to put it
> in the session. That is what is causing the
> NullPointerException.
>
> Then add a <pg:param name="fieldname"/> tag inside
> the <pg:index/>
> tag. This will add "fieldname" to the list of
> parameters that will
> be preserved and passed to future pages.
>
> -James
>
> On Mon, Feb 12, 2001 at 09:02:00AM -0800, Dan Lopez
> wrote:
> > 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)
> >
> >
> >
>
=== message truncated ===
__________________________________________________
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
