The problem is that the url parameter name is "sqlstmt" and
you put <pg:param name="sqlstmts"/> instead.
-James
On Mon, Feb 12, 2001 at 12:14:44PM -0800, Dan Lopez wrote:
> 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
===========================================================================
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
