Please could you send me the sql log? Henner
> -----Urspr�ngliche Nachricht----- > Von: Lazaro Fung [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 26. Januar 2003 20:47 > An: Henner Kollmann > Cc: dbf > Betreff: Re: [dbforms] Is the filter & navegator fixed ? > > > Henner > > filter="agenciaId<>0" works fine. > > But when I put filter="agenciaId NOTISNULL" it only show the > firts, and when I try to go Next Or Last, it not show the > <db:dbform> tag content. > > LFung > > ----- Original Message ----- > From: "Henner Kollmann" <[EMAIL PROTECTED]> > To: "'Lazaro Fung'" <[EMAIL PROTECTED]> > Cc: "dbf" <[EMAIL PROTECTED]> > Sent: Sunday, January 26, 2003 12:54 PM > Subject: AW: [dbforms] Is the filter & navegator fixed ? > > > 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 =omething 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
