Re: [dbforms] Problem with new filter tag

Wed, 29 Oct 2003 12:38:31 -0800


Just in case,
Heres the all the code contained in my jsp:
<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<%@ taglib uri="/WEB-INF/pow2webgui.tld" prefix="gui" %>
<%@ page import="java.util.*, java.text.*" %>
<%int i=0;String formname = request.getParameter("name");String formid = request.getParameter("id");%>
<html xmlns:db="http://www.wap-force.net/dbforms">
<head>
<SCRIPT LANGUAGE="_javascript_" SRC=""></SCRIPT>
<%if  (session.getValue("isLogin") == null)
 response.sendRedirect("./index.jsp");%>
<db:base/>
<title><%=formname%> - <%=formid%></title>
<link href="" rel="stylesheet"/>
 </head>
<body class="clsPageBody" style="font-size:12px">
<HEAD>
  <LINK rel="stylesheet" href="">
  <LINK rel="stylesheet" href="">
</HEAD>
<center>
<gui:window  prototype="boWindow" render="bottom" />
<gui:window title="<%=formname%>" prototype="boWindow" color="#f0f0f0">
<table align="center" border="0" width="100%" cellspacing="0" cellpadding="0" class="clsMainMenuTable">
<td class="clsMainMenu">
<td>
</td>
 
<td align ="right">
<table border="0"  cellspacing="0" cellpadding="0" class="clsMainMenuTable">
<tr class="clsMainMenuTableRow">
 

</tr>
</table>
</td>
</tr>
</table>
<db:dbform multipart="false" autoUpdate="false" followUp="<%="/form.jsp?name="+formname+"&id="+formid%>" maxRows="2" tableName="FORM">
<db:header>
<table align="center" >
<tr class="clsHeaderDataTableRow" valign="middle">
<td> </td>
<td class="clsHeaderDataTableCell" align="center">
<p align="center"><b>FORM_ID</b></td>
<td class="clsHeaderDataTableCell" align="center"><b>FORM_NAME</b></td>
<td class="clsHeaderDataTableCell" align="center"><b>PARENT</b></td>
<td class="clsHeaderDataTableCell" align="center"><b>FILENAME</b></td>
<td colspan="2" align="center">&nbsp;</td>
</tr>
<tr class="clsHeaderDataTableRow" valign="middle">
<td/>
<td/>
<td/>
<td/>
<td/>
<td/>
<td/>
<td colspan="2">&nbsp;</td>
</tr>
</db:header>
<db:errors/>
<db:body>
<tr class="<%= (i++%2==0) ? "clsOddDataTableRow" : "clsEvenDataTableRow" %>">
<tr class="clsMainMenuTableRow">
<td>
<db:associatedRadio name="radio_FORM"/>
</td>
       
<td>
<db:textField styleClass="clsInputStyle" size="10" fieldName="FORM_ID"/>
</td>
<td>
<db:textField styleClass="clsInputStyle" size="25" fieldName="FORM_NAME"/>
</td>
<td>
<db:textField styleClass="clsInputStyle" size="10" fieldName="PARENT_FORM_ID"/>
</td>
<td>
<db:textField styleClass="clsInputStyle" size="25" fieldName="FILENAME"/>
</td>
<td>
<a href=""'"+(String)currentRow_FORM.get("LAST_CHANGED_BY")+"','"+(String)currentRow_FORM.get("LAST_CHANGED_WHEN")+"','"+(String)currentRow_FORM.get("CREATED_WHEN")+"','"+(String)currentRow_FORM.get("CREATED_BY")+"'"%>);">[Info]</a>
</td>
<%SimpleDateFormat sdfInput = 
 new SimpleDateFormat( "yyyy-MM-dd" );
 Date sysdate = new Date();%>
<td>
<db:textField styleClass="clsInputStyle" size="0" overrideValue="<%=(String)session.getValue("User")%>" hidden="true" fieldName="LAST_CHANGED_BY"/>
</td>
<td>
<db:dateField styleClass="clsInputStyle" size="3" overrideValue="<%sdfOutput.format( sysdate )%>" hidden="true" fieldName="LAST_CHANGED_WHEN"/>
</td>
</tr> 
 </db:body>
<db:footer> 
          </table>

    
<table border="0" align="center">
<tr valign="middle">
<db:filter>
 <db:filterCondition label="form id like">
  FORM_ID LIKE '%?%'
  <db:filterValue/>
 </db:filterCondition>
 
 <db:filterCondition label="form id equal to">
  FORM_ID = '?'
  <db:filterValue type="select">
   <db:queryData name="q1" query="select FORM_ID as n1, FORM_ID as n2 from FORM order by FORM_ID"/>
  </db:filterValue>
 </db:filterCondition>
</db:filter>
 </tr> 
<tr valign="middle">
<hr width="400"/>
</tr>
<tr>
<td align="right">
<db:navFirstButton styleClass="clsButtonStyle" style="width:90" caption="&lt;&lt; First"/>
</td>
<td align="center">
<db:navPrevButton styleClass="clsButtonStyle" style="width:90" caption="&lt; Previous"/>
</td>
<td align="center">
<db:navNextButton styleClass="clsButtonStyle" style="width:90" caption="Next &gt;"/>
</td>
<td align="left">
<db:navLastButton styleClass="clsButtonStyle" style="width:90" caption="Last &gt;&gt;"/>
</td>
</tr>
</table>
<table border="0" align="center">
<tr valign="middle">
<hr width="400"/>
</tr>
<tr>
<td align="center">
<db:updateButton styleClass="clsButtonStyle" style="width:90" associatedRadio="radio_FORM" caption="Update"/>
</td>
<td align="center">
<db:deleteButton styleClass="clsButtonStyle" style="width:90" associatedRadio="radio_FORM" caption="Delete"/>
</td>
<td align="center">
<db:navNewButton styleClass="clsButtonStyle" followUp="<%="/form_single.jsp?name="+formname+"&id="+formid%>" caption="Insert New ..."/>
</td>
</tr>
</table>
</db:footer>
</db:dbform>
</gui:window>
</center>
</body>
</html>

joe grind <[EMAIL PROTECTED]> wrote:

Hello everyone,

I dont think i have said this but thanks for the good work on dbforms and for the quick responses for my request for help. I am trying to use the new filter tags.

My code look something like this :

<db:filter>
 <db:filterCondition label="form id like">
  FORM_ID LIKE '%?%'
  <db:filterValue/>
 </db:filterCondition>
 
 <db:filterCondition label="form id equal to">
  FORM_ID = '?'
  <db:filterValue type="select">
   <db:queryData name="q1" query="select FORM_ID as n1, FORM_ID as n2 from FORM order by FORM_ID"/>
  </db:filterValue>
 </db:filterCondition>
</db:filter>

this code is contained within my footer tags. I see the filter boxes with the criteria when i select the criteria but when I click set, nothing happens. Also if i click set then update or delete, the dbforms  crashes. I am also not sure what set is supposed to do. Is it supposed to refresh the current dbform showing only the data returned by my filter criteria? Anyone who can share information on this, your help will be greatly appreciated. Thanks.

 

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Reply via email to