Could
you give us a little bit more information what's not working? e.g. the generated
sql query? Some logging output?
Which
version do you use?
Thanks
Henner
Kollmann
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Giannandrea Castaldi
Gesendet: Montag, 20. September 2004 10:59
An: [EMAIL PROTECTED]
Betreff: [dbforms] Problem with filter tagHi all,I'm trying to use the tag filter but it doesn't work. I've specified a filter of type select and the combo is correctly filled with phone numbers I want to use to apply the filter but when I set a number there are all the rows. The filter should select rows with the specified number, I'm using 'MOBILE_DESTINATION = ?'.Any suggestions? Here below there is my jsp.Thanks.Giannandrea<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<% int i=0; %><html xmlns:db="http://www.wap-force.com/dbforms">
<head>
<db:base/>
<title>Customer Care Tool</title>
<link href="" rel="stylesheet"/>
</head>
<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 align="center">
<span class="clsMainMenu">Messaggi in ingresso e uscita</span>
</td>
</tr>
</table>
</td>
</tr>
</table><db:dbform multipart="false" autoUpdate="false" followUp="/MESSAGE_list.jsp" maxRows="20" tableName="CC_MESSAGE" orderBy="REQUEST_DATE desc, TRANSACTION_ID desc">
<db:hasNoRecords message="<CENTER>Nessun messaggio trovato con questo numero</CENTER>"></db:hasNoRecords>
<db:hasRecords>
<db:header>
<db:filter>
<db:filterCondition label="msisdn">
MOBILE_DESTINATION = ?
<db:filterValue type="select">
<db:queryData name="q1" query="select distinct MOBILE_DESTINATION as n1, MOBILE_DESTINATION as n2 from CC_MESSAGE"/>
</db:filterValue>
</db:filterCondition>
</db:filter>
<db:errors/>
<table id="transaction_list" align="center" >
<tr class="clsHeaderDataTableRow">
<td class="clsHeaderDataTableCell">ID</td>
<td class="clsHeaderDataTableCell">CUSTOMER</td>
<td class="clsHeaderDataTableCell">SERVICE</td>
<td class="clsHeaderDataTableCell">REQUEST DATE</td>
<td class="clsHeaderDataTableCell">MO/MT</td>
<td class="clsHeaderDataTableCell">MOBILE DESTINATION</td>
<td class="clsHeaderDataTableCell">OPERATOR</td>
<td class="clsHeaderDataTableCell">REQUEST BODY</td>
<td class="clsHeaderDataTableCell">TEXT</td>
<td class="clsHeaderDataTableCell">CONTENT</td>
<td class="clsHeaderDataTableCell">DELIVERY STATUS</td>
<td class="clsHeaderDataTableCell">BILLING STATUS</td>
</tr>
</db:header>
<db:body allowNew="false">
<tr class="<%= (i++%2==0) ? "clsOddDataTableRow" : "clsEvenDataTableRow" %>">
<td><%= currentRow_CC_MESSAGE.get("TRANSACTION_ID") %></td>
<td><%= currentRow_CC_MESSAGE.get("CUSTOMER") %></td>
<td><%= currentRow_CC_MESSAGE.get("SERVICE") %></td>
<td><db:dateLabel fieldName="REQUEST_DATE" pattern="dd.MM.yyyy HH:mm:ss"/></td>
<td><%= currentRow_CC_MESSAGE.get("MT_MO") %></td>
<td><%= currentRow_CC_MESSAGE.get("MOBILE_DESTINATION") %></td>
<td><%= currentRow_CC_MESSAGE.get("OPERATOR") %></td>
<td><%= currentRow_CC_MESSAGE.get("REQUEST_BODY") %></td>
<td><%= currentRow_CC_MESSAGE.get("TEXT") %></td>
<td><%= currentRow_CC_MESSAGE.get("CONTENT") %></td>
<td><%= currentRow_CC_MESSAGE.get("DELIVERY_STATUS") %></td>
<td><%= currentRow_CC_MESSAGE.get("BILLING_STATUS") %></td>
</tr>
</db:body>
<db:footer></table>
<center>
<db:navFirstButton caption="<< First" />
<db:navPrevButton caption="< Previous" />
<db:navNextButton caption="Next >" />
<db:navLastButton caption="Last >>" />
</center>
</db:footer>
</db:hasRecords>
</db:dbform></body>
</html>
