You are calling Long.parseLong with a string parameter that is null
(either equal to null or is a literal "null" - I can't remember how this
message is structured right now).
You are making the call from line 77 of the generated .java file for
the JSP page.
Randy
> -----Original Message-----
> From: Robert Keddie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 15, 2002 1:00 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: Jim Saullo
> Subject: RE: Novice here! Classpath issue...Tomcat
> 3.3/IIS5.0/Win2k/Oracle
>
>
> I did everything you said and now I get this error( last
> error gone which is good!)...what could this mean?
>
> 2002-03-15 08:49:10 - Ctx(/marion) : Exception in R( /marion
> + /permit_details.jsp + null) - javax.servlet.Ser
> vletException: null
> at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(
> PageContextImpl.java:460)
> at permit_details_1._jspService(permit_details_1.java:430)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at
> org.apache.tomcat.facade.ServletHandler.doService(ServletHandl
> er.java:484)
> at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
> at org.apache.tomcat.core.Handler.service(Handler.java:235)
> at
> org.apache.tomcat.facade.ServletHandler.service(ServletHandler
> .java:432)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextM
> anager.java:915)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
> at
> org.apache.tomcat.modules.server.Ajp12Interceptor.processConne
> ction(Ajp12Interceptor.java:207)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.java:477)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:517)
> at java.lang.Thread.run(Thread.java:484)
> Root cause:
> java.lang.NumberFormatException: null
> at java.lang.Long.parseLong(Long.java:279)
> at java.lang.Long.parseLong(Long.java:363)
> at permit_details_1._jspService(permit_details_1.java:77)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at
> org.apache.tomcat.facade.ServletHandler.doService(ServletHandl
> er.java:484)
> at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
> at org.apache.tomcat.core.Handler.service(Handler.java:235)
> at
> org.apache.tomcat.facade.ServletHandler.service(ServletHandler
> .java:432)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextM
> anager.java:915)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
> at
> org.apache.tomcat.modules.server.Ajp12Interceptor.processConne
> ction(Ajp12Interceptor.java:207)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.java:477)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:517)
> at java.lang.Thread.run(Thread.java:484)
>
> Robert Keddie
> web development
> Marion County, FL
>
> Robert Keddie
> web development
> Marion County, FL
>
> >>> [EMAIL PROTECTED] 03/14/02 11:19AM >>>
> Note that the tomcat.bat batch file includes:
>
> set CLASSPATH=%TOMCAT_INSTALL%\lib\tomcat.jar
>
> which will override your previously set CLASSPATH environment
> variable. For info on the recommended way to add classes to
> Tomcat 3.3, please refer to:
>
> <http://jakarta.apache.org/tomcat/tomcat-3.3-doc/tomcat-ug.htm
> l#configuring_classes>
>
> I would recommend as a first approach, renaming the two ".zip" files
> to ".jar" files and copy them to TOMCAT_HOME\lib\common.
>
> Cheers,
> Larry
>
> > -----Original Message-----
> > From: Robert Keddie [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 14, 2002 11:02 AM
> > To: [EMAIL PROTECTED]
> > Cc: Jim Saullo
> > Subject: Novice here! Classpath issue...Tomcat
> 3.3/IIS5.0/Win2k/Oracle
> >
> >
> > I recieve the following error, but I shouldn't because the
> > classpath has the following :
> > CLASSPATH=.;C:\jdk1.3.1;C:\Oracle\Ora81\jdbc\lib\classes111.zi
> > p;C:\Oracle\Ora81\jdbc\lib\nls_charset11.zip;
> >
> > Im using Tomcat 3.3 on IIS 5.0 on Win 2k ... the page source
> > is at the bottom.
> > When I first received this error I made subfolders under
> > classes/oracle/jbdc/driver/* with the oracle driver classes
> > but it then couldnt process this part
> > "call.registerOutParameter(2, OracleTypes.CURSOR);
> > call.registerOutParameter(3, OracleTypes.CURSOR)" of the page
> > source at bottom.
> > Please anyone help this novice!
> >
> > 2002-03-14 08:25:52 - ServerXmlReader:
> > Config=$TOMCAT_HOME\conf\server.xml
> > 2002-03-14 08:25:52 - PathSetter: home=C:\jakarta-tomcat
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-127.0.0.1.xml
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-admin.xml
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-examples.xml
> > 2002-03-14 08:25:52 - AutoWebApp: Loaded from config:
> > DEFAULT:/admin 2002-03-14 08:25:52 - AutoWebApp: Loaded from
> > config: DEFAULT:/examples 2002-03-14 08:25:52 - AutoWebApp:
> > Auto-Adding DEFAULT:/marion 2002-03-14 08:25:52 - AutoWebApp:
> > Auto-Adding DEFAULT:/ 2002-03-14 08:25:52 - ContextManager:
> > Tomcat configured and in stable state 2002-03-14 08:25:52 -
> > ContextManager: Adding DEFAULT:/admin 2002-03-14 08:25:52 -
> > ContextManager: Adding DEFAULT:/examples 2002-03-14 08:25:52
> > - ContextManager: Adding DEFAULT:/marion 2002-03-14 08:25:52
> > - ContextManager: Adding DEFAULT:/ROOT
> > EmbededTomcat: Init time 2750
> > 2002-03-14 08:25:53 - Http10Interceptor: Starting on 8080
> > 2002-03-14 08:25:53 - Ajp12Interceptor: Starting on 8007
> > 2002-03-14 08:25:53 - Ajp13Interceptor: Starting on 8009
> > EmbededTomcat: Startup time 421
> > 2002-03-14 10:39:55 - SessionIdGenerator: Created random
> > class java.security.SecureRandom 2002-03-14 10:40:17 -
> > Ctx(/marion) : Compiling: /permit_details.jsp to
> > permit_details_0 2002-03-14 10:40:27 - Ctx(/marion) : compile
> > error: req=R( /marion + /permit_details.jsp + null) - org.apache.
> > jasper.JasperException: Unable to compile
> > C:\jakarta-tomcat\work\DEFAULT\marion\permit_details_1.java:6:
> > Packa ge oracle.jdbc.driver not found in import. import
> > oracle.jdbc.driver.*;
> > ^
> > 1 error
> >
> > at
> >
> org.apache.tomcat.facade.JasperLiaison.javac(JspInterceptor.java:791)
> > at
> > org.apache.tomcat.facade.JasperLiaison.processJspFile(JspInter
> > ceptor.java:632)
> > at
> > org.apache.tomcat.facade.JspInterceptor.requestMap(JspIntercep
> > tor.java:446)
> > at
> > org.apache.tomcat.core.ContextManager.processRequest(ContextMa
> > nager.java:966)
> > at
> > org.apache.tomcat.core.ContextManager.internalService(ContextM
> > anager.java:873)
> > at
> >
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
> > at
> > org.apache.tomcat.modules.server.Ajp12Interceptor.processConne
> > ction(Ajp12Interceptor.java:207)
> > at
> > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> > nt.java:477)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:517)
> > at java.lang.Thread.run(Thread.java:484)
> >
> > page in question:
> >
> > <%@ page import="marion.*" %>
> >
> > <%@ page import="java.sql.*" %>
> >
> > <%@ page import="oracle.jdbc.driver.*" %>
> >
> > <HTML>
> > <HEAD>
> > <TITLE>Permit Details</TITLE>
> > <!-- author Jim Saullo [EMAIL PROTECTED] -->
> > <!-- this page last revised 09/27/01 by Jim Saullo -->
> > <style>
> > .monospace { font-family:monospace; }
> > </style>
> > <script>
> > function inspections(temp) {
> > location=("inspections.jsp?q_nbr="+temp) }
> > function reviews(revw) {
> > location=("reviews.jsp?r_nbr="+revw) }
> > function certificates(cert) {
> > location=("certificates.jsp?s_nbr="+cert) }
> > function subcon(pnbr) {
> location=("subcontractor.jsp?nbr="+pnbr) }
> > function menu() { location=("../marion_home.html") }
> > function back() { window.history.back() }
> > </script>
> > <LINK REL=StyleSheet href="../style.css" TYPE="text/css"
> > media=screen> </HEAD>
> >
> >
> > <table border="0" width="665" cellspacing="0"
> > cellpadding="0"> <tr valign="TOP">
> > <td valign="TOP" width="65" align="center"></td>
> > <td valign="TOP" width="600"><body bgcolor="#FFFFFF"
> > background="../images/resultback.jpg" text="#000000"><map
> > name="home"><area alt="Back To MCBCC Home Page"
> > coords="361,83,432,100"
> > href="http://www.marioncountyfl.org/index.shtml";>
> > </map><% int count=0; String spacer = "No Impact Fees";
> > String p_nbr = request.getParameter("nbr");%>
> >
> >
> > <center>
> > <p><img src="../Images/title.jpg" width=433 height=102
> > border=0 usemap="#home"><br>
> > <a
> > href="http://www.marioncountyfl.org/departments/building/index.htm";
> >
> > style="color:#82B7A7;font-size:16;font-weight:bold;font-family
> > :verdana,arial">
> > Back To Building Home Page
> > </a>
> > </center>
> >
> > <form method=post ACTION="permit_third.jsp">
> > <center>
> > <% marion.DbBean1 dbConn=new marion.DbBean1();
> > Connection conn=(Connection)dbConn.getConnection();
> > CallableStatement call=conn.prepareCall("{call
> > cdp_permits.permit_number_results(?,?,?)}");
> > call.setLong(1,Long.parseLong(p_nbr));
> > call.registerOutParameter(2, OracleTypes.CURSOR);
> > call.registerOutParameter(3, OracleTypes.CURSOR);
> > call.execute(); ResultSet rset = (ResultSet)call.getObject(2);
> > while(rset.next()) {%><table border=1
> > width=600><tr><td><b><font color=blue>Permit
> > Data:</font></b><br>
> > <b>Permit
> > Number:</b> <%= rset.getString(1)
> > %> <b>Parcel ID:</b> <%=
> > rset.getString(2)
> > %> <b>Status:</b> <%=
> > rset.getString(3)
> > %><br><br> &nbs
> > p; <b>Permit
> > Type:</b> <%=
> > rset.getString(4) %> - <%=
> > rset.getString(5)
> > %><br><br> &nbs
> > p; <b>Block:</b>  
> > ; &
> > nbsp; <%= rset.getString(6)
> > %> <b>Lot:</b> <%=
> > rset.getString(7) %> <b>Total
> > SQFT:</b> <%= rset.getString(8)
> > %> <b>Job Value:</b> <%=
> > rset.getString(31)
> > %><br> &n
> > bsp; <b>Subdivision:</b> &nb
> > sp; <%= rset.getString(9)
> > %><br> &n
> > bsp; <b>Street
> > Address:</b> <%= rset.getString(10)
> > %> <%= rset.getString(11) %> <%= rset.getString(12)
> > %> <%= rset.getString(13) %><br></td></tr></table><table
> > border=1 width=600><tr><td><b><font color=blue>Applicant
> > Info:</font></b><br>
> > <b>Issued
> > Date:</b> <%=
> > rset.getString(14)
> > %> <b>Type:</b>
> > <%= rset.getString(15)
> > %><br> &n
> > bsp; <b>Name:</b> &nbs
> > p;
> > <%= rset.getString(16) %><b>Job Phone:</b> <%=
> > rset.getString(17) %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Owner
> > Info:</font></b><br>
> > <b>Name:</b> &n
> > bsp; <%=
> > rset.getString(18)
> > %><br> &n
> > bsp; <b>Address:</b> &
> > nbsp;<%= rset.getString(19)
> > %><br> &n
> > bsp; &nbs
> > p;
> > <%= rset.getString(20) %> <%=
> > rset.getString(21) %> <%= rset.getString(22)
> > %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Contractor
> > Info:</font></b><br>
> > <b>License
> > No.:</b> <%= rset.getString(23)
> > %> <b>Name:</b>
> > <%= rset.getString(24)
> > %><br><br> &nbs
> > p; <b>Address:</b> <%=
> > rset.getString(25)
> > %><br> &n
> > bsp; &nbs
> > p; <%=
> > rset.getString(26) %> <%= rset.getString(27) %> <%=
> > rset.getString(28)
> > %><br><br> &nbs
> > p; <b>Phone:</b> <%=
> > rset.getString(29) %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Impact
> > Fees:</font> &n
> > bsp;<font color=black>Other fees may be due on this
> > permit</font></b><tr<th width=550> </th><th width=25>Amt
> > Due</th><th width=25>Amt Paid</th></tr><%
> > ResultSet rset2 = (ResultSet)call.getObject(3);
> > while(rset2.next()) {%>
> >
> > <tr><td><%= rset2.getString(1) %></td>
> > <td><%= rset2.getString(2) %></td>
> > <td><%= rset2.getString(3) %></td></tr>
> > <%count = count+1; %>
> > <% } %>
> > <% if (count == 0) { %>
> > <tr><td> <%= spacer %> </td></tr>
> > <% } %>
> > </table><table><br><tr><td><input type="Button"
> > value="Inspections" onClick=inspections(<%= rset.getString(1)
> > %>)><input type="button" value="Dept. Reviews"
> > onClick=reviews(<%= rset.getString(1) %>)><input
> > type="button" value="Contractor" onClick=certificates(<%=
> > rset.getString(30) %>)> <input type="button" value="Sub
> > Contractor" onClick=subcon(<%= rset.getString(1) %>)><br><br>
> > <center> <input type="Button" value="Return to Menu"
> > onClick=menu()> <input type="Button" value="Back"
> > onClick=back()></center></td></tr></table><%count = count+1;
> > %><% } %> <% System.out.println(count); %> <%if (count == 0) { %>
> > <br><br>
> > <center><table border=1 width=55%><tr><td>
> > <center>
> > <b><font color=black size=-1>No Records Found</font></b>
> > </center>
> > </td></tr></table>
> > <br><br>
> > <table><tr><td>
> > <input type="Button" value="Return to Menu" onClick=menu()>
> > <input type="Button" value="Back"
> > onClick=back()>
> > <br><br>
> > </td></tr></table></center>
> > <% } %>
> >
> > </form>
> >
> >
> > </p></td></tr></table>
> >
> > </center>
> > </BODY>
> > </HTML>
> >
> >
> >
> >
> > Robert Keddie
> > web development
> > Marion County, FL
> >
> > --
> > To unsubscribe:
> <mailto:[EMAIL PROTECTED]>
> > For additional commands:
> <mailto:[EMAIL PROTECTED]>
> > Troubles with the list:
> <mailto:[EMAIL PROTECTED]>
> >
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
>
> >>> [EMAIL PROTECTED] 03/14/02 11:19AM >>>
> Note that the tomcat.bat batch file includes:
>
> set CLASSPATH=%TOMCAT_INSTALL%\lib\tomcat.jar
>
> which will override your previously set CLASSPATH environment
> variable. For info on the recommended way to add classes to
> Tomcat 3.3, please refer to:
>
> <http://jakarta.apache.org/tomcat/tomcat-3.3-doc/tomcat-ug.htm
> l#configuring_classes>
>
> I would recommend as a first approach, renaming the two ".zip" files
> to ".jar" files and copy them to TOMCAT_HOME\lib\common.
>
> Cheers,
> Larry
>
> > -----Original Message-----
> > From: Robert Keddie [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 14, 2002 11:02 AM
> > To: [EMAIL PROTECTED]
> > Cc: Jim Saullo
> > Subject: Novice here! Classpath issue...Tomcat
> 3.3/IIS5.0/Win2k/Oracle
> >
> >
> > I recieve the following error, but I shouldn't because the
> > classpath has the following :
> > CLASSPATH=.;C:\jdk1.3.1;C:\Oracle\Ora81\jdbc\lib\classes111.zi
> > p;C:\Oracle\Ora81\jdbc\lib\nls_charset11.zip;
> >
> > Im using Tomcat 3.3 on IIS 5.0 on Win 2k ... the page source
> > is at the bottom.
> > When I first received this error I made subfolders under
> > classes/oracle/jbdc/driver/* with the oracle driver classes
> > but it then couldnt process this part
> > "call.registerOutParameter(2, OracleTypes.CURSOR);
> > call.registerOutParameter(3, OracleTypes.CURSOR)" of the page
> > source at bottom.
> > Please anyone help this novice!
> >
> > 2002-03-14 08:25:52 - ServerXmlReader:
> > Config=$TOMCAT_HOME\conf\server.xml
> > 2002-03-14 08:25:52 - PathSetter: home=C:\jakarta-tomcat
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-127.0.0.1.xml
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-admin.xml
> > 2002-03-14 08:25:52 - ContextXmlReader: Context
> > config=$TOMCAT_HOME\conf\apps-examples.xml
> > 2002-03-14 08:25:52 - AutoWebApp: Loaded from config:
> > DEFAULT:/admin 2002-03-14 08:25:52 - AutoWebApp: Loaded from
> > config: DEFAULT:/examples 2002-03-14 08:25:52 - AutoWebApp:
> > Auto-Adding DEFAULT:/marion 2002-03-14 08:25:52 - AutoWebApp:
> > Auto-Adding DEFAULT:/ 2002-03-14 08:25:52 - ContextManager:
> > Tomcat configured and in stable state 2002-03-14 08:25:52 -
> > ContextManager: Adding DEFAULT:/admin 2002-03-14 08:25:52 -
> > ContextManager: Adding DEFAULT:/examples 2002-03-14 08:25:52
> > - ContextManager: Adding DEFAULT:/marion 2002-03-14 08:25:52
> > - ContextManager: Adding DEFAULT:/ROOT
> > EmbededTomcat: Init time 2750
> > 2002-03-14 08:25:53 - Http10Interceptor: Starting on 8080
> > 2002-03-14 08:25:53 - Ajp12Interceptor: Starting on 8007
> > 2002-03-14 08:25:53 - Ajp13Interceptor: Starting on 8009
> > EmbededTomcat: Startup time 421
> > 2002-03-14 10:39:55 - SessionIdGenerator: Created random
> > class java.security.SecureRandom 2002-03-14 10:40:17 -
> > Ctx(/marion) : Compiling: /permit_details.jsp to
> > permit_details_0 2002-03-14 10:40:27 - Ctx(/marion) : compile
> > error: req=R( /marion + /permit_details.jsp + null) - org.apache.
> > jasper.JasperException: Unable to compile
> > C:\jakarta-tomcat\work\DEFAULT\marion\permit_details_1.java:6:
> > Packa ge oracle.jdbc.driver not found in import. import
> > oracle.jdbc.driver.*;
> > ^
> > 1 error
> >
> > at
> >
> org.apache.tomcat.facade.JasperLiaison.javac(JspInterceptor.java:791)
> > at
> > org.apache.tomcat.facade.JasperLiaison.processJspFile(JspInter
> > ceptor.java:632)
> > at
> > org.apache.tomcat.facade.JspInterceptor.requestMap(JspIntercep
> > tor.java:446)
> > at
> > org.apache.tomcat.core.ContextManager.processRequest(ContextMa
> > nager.java:966)
> > at
> > org.apache.tomcat.core.ContextManager.internalService(ContextM
> > anager.java:873)
> > at
> >
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
> > at
> > org.apache.tomcat.modules.server.Ajp12Interceptor.processConne
> > ction(Ajp12Interceptor.java:207)
> > at
> > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> > nt.java:477)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:517)
> > at java.lang.Thread.run(Thread.java:484)
> >
> > page in question:
> >
> > <%@ page import="marion.*" %>
> >
> > <%@ page import="java.sql.*" %>
> >
> > <%@ page import="oracle.jdbc.driver.*" %>
> >
> > <HTML>
> > <HEAD>
> > <TITLE>Permit Details</TITLE>
> > <!-- author Jim Saullo [EMAIL PROTECTED] -->
> > <!-- this page last revised 09/27/01 by Jim Saullo -->
> > <style>
> > .monospace { font-family:monospace; }
> > </style>
> > <script>
> > function inspections(temp) {
> > location=("inspections.jsp?q_nbr="+temp) }
> > function reviews(revw) {
> > location=("reviews.jsp?r_nbr="+revw) }
> > function certificates(cert) {
> > location=("certificates.jsp?s_nbr="+cert) }
> > function subcon(pnbr) {
> location=("subcontractor.jsp?nbr="+pnbr) }
> > function menu() { location=("../marion_home.html") }
> > function back() { window.history.back() }
> > </script>
> > <LINK REL=StyleSheet href="../style.css" TYPE="text/css"
> > media=screen> </HEAD>
> >
> >
> > <table border="0" width="665" cellspacing="0"
> > cellpadding="0"> <tr valign="TOP">
> > <td valign="TOP" width="65" align="center"></td>
> > <td valign="TOP" width="600"><body bgcolor="#FFFFFF"
> > background="../images/resultback.jpg" text="#000000"><map
> > name="home"><area alt="Back To MCBCC Home Page"
> > coords="361,83,432,100"
> > href="http://www.marioncountyfl.org/index.shtml";>
> > </map><% int count=0; String spacer = "No Impact Fees";
> > String p_nbr = request.getParameter("nbr");%>
> >
> >
> > <center>
> > <p><img src="../Images/title.jpg" width=433 height=102
> > border=0 usemap="#home"><br>
> > <a
> > href="http://www.marioncountyfl.org/departments/building/index.htm";
> >
> > style="color:#82B7A7;font-size:16;font-weight:bold;font-family
> > :verdana,arial">
> > Back To Building Home Page
> > </a>
> > </center>
> >
> > <form method=post ACTION="permit_third.jsp">
> > <center>
> > <% marion.DbBean1 dbConn=new marion.DbBean1();
> > Connection conn=(Connection)dbConn.getConnection();
> > CallableStatement call=conn.prepareCall("{call
> > cdp_permits.permit_number_results(?,?,?)}");
> > call.setLong(1,Long.parseLong(p_nbr));
> > call.registerOutParameter(2, OracleTypes.CURSOR);
> > call.registerOutParameter(3, OracleTypes.CURSOR);
> > call.execute(); ResultSet rset = (ResultSet)call.getObject(2);
> > while(rset.next()) {%><table border=1
> > width=600><tr><td><b><font color=blue>Permit
> > Data:</font></b><br>
> > <b>Permit
> > Number:</b> <%= rset.getString(1)
> > %> <b>Parcel ID:</b> <%=
> > rset.getString(2)
> > %> <b>Status:</b> <%=
> > rset.getString(3)
> > %><br><br> &nbs
> > p; <b>Permit
> > Type:</b> <%=
> > rset.getString(4) %> - <%=
> > rset.getString(5)
> > %><br><br> &nbs
> > p; <b>Block:</b>  
> > ; &
> > nbsp; <%= rset.getString(6)
> > %> <b>Lot:</b> <%=
> > rset.getString(7) %> <b>Total
> > SQFT:</b> <%= rset.getString(8)
> > %> <b>Job Value:</b> <%=
> > rset.getString(31)
> > %><br> &n
> > bsp; <b>Subdivision:</b> &nb
> > sp; <%= rset.getString(9)
> > %><br> &n
> > bsp; <b>Street
> > Address:</b> <%= rset.getString(10)
> > %> <%= rset.getString(11) %> <%= rset.getString(12)
> > %> <%= rset.getString(13) %><br></td></tr></table><table
> > border=1 width=600><tr><td><b><font color=blue>Applicant
> > Info:</font></b><br>
> > <b>Issued
> > Date:</b> <%=
> > rset.getString(14)
> > %> <b>Type:</b>
> > <%= rset.getString(15)
> > %><br> &n
> > bsp; <b>Name:</b> &nbs
> > p;
> > <%= rset.getString(16) %><b>Job Phone:</b> <%=
> > rset.getString(17) %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Owner
> > Info:</font></b><br>
> > <b>Name:</b> &n
> > bsp; <%=
> > rset.getString(18)
> > %><br> &n
> > bsp; <b>Address:</b> &
> > nbsp;<%= rset.getString(19)
> > %><br> &n
> > bsp; &nbs
> > p;
> > <%= rset.getString(20) %> <%=
> > rset.getString(21) %> <%= rset.getString(22)
> > %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Contractor
> > Info:</font></b><br>
> > <b>License
> > No.:</b> <%= rset.getString(23)
> > %> <b>Name:</b>
> > <%= rset.getString(24)
> > %><br><br> &nbs
> > p; <b>Address:</b> <%=
> > rset.getString(25)
> > %><br> &n
> > bsp; &nbs
> > p; <%=
> > rset.getString(26) %> <%= rset.getString(27) %> <%=
> > rset.getString(28)
> > %><br><br> &nbs
> > p; <b>Phone:</b> <%=
> > rset.getString(29) %></td></tr></table><table border=1
> > width=600><tr><td><b><font color=blue>Impact
> > Fees:</font> &n
> > bsp;<font color=black>Other fees may be due on this
> > permit</font></b><tr<th width=550> </th><th width=25>Amt
> > Due</th><th width=25>Amt Paid</th></tr><%
> > ResultSet rset2 = (ResultSet)call.getObject(3);
> > while(rset2.next()) {%>
> >
> > <tr><td><%= rset2.getString(1) %></td>
> > <td><%= rset2.getString(2) %></td>
> > <td><%= rset2.getString(3) %></td></tr>
> > <%count = count+1; %>
> > <% } %>
> > <% if (count == 0) { %>
> > <tr><td> <%= spacer %> </td></tr>
> > <% } %>
> > </table><table><br><tr><td><input type="Button"
> > value="Inspections" onClick=inspections(<%= rset.getString(1)
> > %>)><input type="button" value="Dept. Reviews"
> > onClick=reviews(<%= rset.getString(1) %>)><input
> > type="button" value="Contractor" onClick=certificates(<%=
> > rset.getString(30) %>)> <input type="button" value="Sub
> > Contractor" onClick=subcon(<%= rset.getString(1) %>)><br><br>
> > <center> <input type="Button" value="Return to Menu"
> > onClick=menu()> <input type="Button" value="Back"
> > onClick=back()></center></td></tr></table><%count = count+1;
> > %><% } %> <% System.out.println(count); %> <%if (count == 0) { %>
> > <br><br>
> > <center><table border=1 width=55%><tr><td>
> > <center>
> > <b><font color=black size=-1>No Records Found</font></b>
> > </center>
> > </td></tr></table>
> > <br><br>
> > <table><tr><td>
> > <input type="Button" value="Return to Menu" onClick=menu()>
> > <input type="Button" value="Back"
> > onClick=back()>
> > <br><br>
> > </td></tr></table></center>
> > <% } %>
> >
> > </form>
> >
> >
> > </p></td></tr></table>
> >
> > </center>
> > </BODY>
> > </HTML>
> >
> >
> >
> >
> > Robert Keddie
> > web development
> > Marion County, FL
> >
> > --
> > To unsubscribe:
<mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
