Shaw When I use filter="agenciaId <> 0" The page not show nothing inside de <db:form> tag.
Neither the navigator button. This is the jsp code: <%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %> <html xmlns:db="http://www.wap-force.com/dbforms";> <head> <db:base/> <title>Single --- file: agente_single.jsp</title> <link href="dbforms.css" rel="stylesheet"/> </head> <script language="javascript" src=<%= "\"" +request.getContextPath() + "/dbformslib/jscal/calendar.js\""%>> </script> <body class="clsPageBody"> <table align="center" border="0" width="100%" cellspacing="0" cellpadding="1" class="clsMainMenuTable"> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="3" class="clsMainMenuTable"> <tr class="clsMainMenuTableRow"> <td> <span class="clsMainMenu">agente</span> </td> <td class="clsMainMenu" align="right"> <a class="clsMainMenu" href="agente_list.jsp">[List]</a> <a class="clsMainMenu" href="menu.jsp">[Menu]</a> <a class="clsMainMenu" href="logout.jsp">[Log out]</a> </td> </tr> </table> </td> </tr> </table> <db:dbform multipart="false" autoUpdate="false" followUp="/agente_single.jsp" maxRows="1" tableName="cliente" formValidatorName="agente" javascriptValidation="true" filter="agenciaId <> 0"> <db:header/> <db:errors/> <db:body> <table width="400" align="center" border="0"> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">agencia</td> <td align="left"> <db:select fieldName="agenciaId" customEntry=","> <db:tableData name = "agencias" foreignTable = "agencia" visibleFields = "agencia_nombre" storeField = "agenciaId" orderBy = "agencia_nombre" /> </db:select> </td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">nombre</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="nombre"/> </td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">apellido</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="apellido"/> </td> </tr> <tr class="clsEvenDataTableRow"> <td style="font-weight: bold" align="left">sexo</td> <td align="left"> <db:select fieldName="sexo" customEntry=","> <db:staticData name="sexos"> <db:staticDataItem key="F" value="Femenino"/> <db:staticDataItem key="M" value="Masculino"/> </db:staticData> </db:select> </td> </tr> <tr class="clsEvenDataTableRow"> <td style="font-weight: bold" align="left">fecha_nacimiento</td> <td align="left"> <db:dateField styleClass="clsInputStyle" size="10" fieldName="fecha_nacimiento" useJsCalendar="true"/></td> </tr> <tr class="clsEvenDataTableRow"> <td style="font-weight: bold" align="left">direccion_postal</td> <td align="left"> <db:textArea styleClass="clsInputStyle" wrap="virtual" rows="3" cols="40" fieldName="direccion_postal"/></td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">pais</td> <td align="left"> <db:select fieldName="pais" customEntry=","> <db:tableData name = "paises" foreignTable = "pais" visibleFields = "pais_nombre" storeField = "paisId" orderBy = "pais_nombre" /> </db:select> </td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">telefono</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="telefono"/></td> </tr> <tr class="clsEvenDataTableRow"> <td style="font-weight: bold" align="left">fax</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="fax"/></td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">email</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="email"/></td> </tr> <tr class="clsEvenDataTableRow"> <td style="font-weight: bold" align="left">login</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="login"/></td> </tr> <tr class="clsOddDataTableRow"> <td style="font-weight: bold" align="left">password</td> <td align="left"> <db:textField styleClass="clsInputStyle" size="50" fieldName="password"/></td> </tr> </table> <br/> <center> <db:insertButton showAlways="false" styleClass="clsButtonStyle" caption="Commit data into agente"/> </center> </db:body> <db:footer> <table border="0" align="center"> <tr> <td align="right"> <db:navFirstButton styleClass="clsButtonStyle" style="width:90" caption="<< First"/> </td> <td align="center"> <db:navPrevButton styleClass="clsButtonStyle" style="width:90" caption="< Previous"/> </td> <td align="center"> <db:navNextButton styleClass="clsButtonStyle" style="width:90" caption="Next >"/> </td> <td align="left"> <db:navLastButton styleClass="clsButtonStyle" style="width:90" caption="Last >>"/> </td> </tr> </table> <table border="0" align="center"> <tr valign="middle"> <td colspan="3"> <hr/> </td> </tr> <tr align="center"> <td align="center"> <db:updateButton styleClass="clsButtonStyle" style="width:90" caption="Update"/> </td> <td align="center"> <db:deleteButton styleClass="clsButtonStyle" style="width:90" caption="Delete"/> </td> <td align="center"> <db:navNewButton styleClass="clsButtonStyle" style="width:90" caption="Insert new"/> </td> </tr> </table> </db:footer> </db:dbform> </body> </html> the field agenciaId is smallint, allow null but the default values is 0, I try to use null values and set the filter="agenciaId is not null" but it show an error. HTTP Status 500 - ---------------------------------------------------------------------------- ---- type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: String index out of range: -1 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 48) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch er.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher .java:356) at org.dbforms.Controller.process(Controller.java:589) at org.dbforms.Controller.doGet(Controller.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:533) at java.lang.Thread.run(Thread.java:536) root cause java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at java.lang.String.substring(String.java:1476) at org.dbforms.taglib.DbFormTag.initFilterFieldValues(DbFormTag.java:2059) at org.dbforms.taglib.DbFormTag.setFilter(DbFormTag.java:501) at org.apache.jsp.agente_single_jsp._jspService(agente_single_jsp.java:159) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 04) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch er.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher .java:356) at org.dbforms.Controller.process(Controller.java:589) at org.dbforms.Controller.doGet(Controller.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:533) at java.lang.Thread.run(Thread.java:536) ---------------------------------------------------------------------------- ---- Apache Tomcat/4.1.12 This is the dbforms-config.xml piece of code: <table name="cliente" defaultVisibleFields="clienteId" > <field name="clienteId" fieldType="smallint" size="4" isKey="true" autoInc="true"/> <field name="login" fieldType="varchar" size="15"/> <field name="password" fieldType="varchar" size="15"/> <field name="nombre" fieldType="varchar" size="40"/> <field name="apellido" fieldType="varchar" size="50"/> <field name="fecha_nacimiento" fieldType="date" size="10"/> <field name="agenciaId" fieldType="smallint" size="4"/> <field name="email" fieldType="varchar" size="50"/> <field name="direccion_postal" fieldType="varchar" size="200"/> <field name="telefono" fieldType="varchar" size="15"/> <field name="fax" fieldType="varchar" size="15"/> <field name="sexo" fieldType="char" size="1"/> <field name="pais" fieldType="smallint" size="4"/> <field name="tipo_pago" fieldType="smallint" size="4"/> <!-- add "granted-privileges" element for security constraints --> </table> Thanks in advance. LFung ----- Original Message ----- From: "shawn" <[EMAIL PROTECTED]> To: "Lazaro Fung" <[EMAIL PROTECTED]> Cc: "jdbforms-interest" <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 7:29 PM Subject: Re: [dbforms] Is the filter & navegator fixed ? > Were you using a whereClause="where ..." in your dbforms tag. > > Apperantly dbforms was designed so that navigation does not work with a > whereClause > > For navigation to work, your page has to be used without a whereClause > but you can still use things like orderBy="..." filter="..." > > With that in mind, please check your pages and let us know what problems > you are still experiencing. > > Considerately, > > Shawn > > On Sat, 2003-01-25 at 02:19, Lazaro Fung wrote: > > Hi > > > > Is the filter used with navegator bug fix ? > > > > TIA > > LFung > -- > shawn <[EMAIL PROTECTED]> > ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
