Hi Lazaro, Please could you remove the blanks soround the <>? Just use filter="agenciaId<>0"?
The filter for not null is the string NOTISNULL! Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im > Auftrag von Lazaro Fung > Gesendet: Sonntag, 26. Januar 2003 18:42 > An: shawn > Cc: jdbforms-interest > Betreff: Re: [dbforms] Is the filter & navegator fixed ? > > > 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(JspServlet > Wrapper.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(Applicat > ionDispatcher. > java:684) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(Appli > cationDispatch > er.java:432) > at > org.apache.catalina.core.ApplicationDispatcher.forward(Applica > tionDispatcher > .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.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2396) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:172 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.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(Http11Process > or.java:405) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle > r.processConne > ction(Http11Protocol.java:380) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi > nt.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.j > ava: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(JspServlet > Wrapper.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(Applicat > ionDispatcher. > java:684) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(Appli > cationDispatch > er.java:432) > at > org.apache.catalina.core.ApplicationDispatcher.forward(Applica > tionDispatcher > .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.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2396) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:172 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.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(Http11Process > or.java:405) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle > r.processConne > ction(Http11Protocol.java:380) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi > nt.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 ------------------------------------------------------- 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
