|
Hi all (and Henner).
Here I have an example based on bookstore where the behaviour of
dbSearchCombo is strange.
I have 2 forms the master and the detail form. In the inner form I put a dbSearchCombo that make a query on BOOK table "where title like '%galaxy%'. When master-dbform is positioned on "Adam Douglas" everything is
fine.
When the master-dbfform is positioned on "Umberto Eco", the second dbSearchCombo retrieves records of books "Hijacking through the Galaxy 1"... but this books aren't binded with Umberto Eco. I'm using 1.1.4pr1 (till the next 15/21 days... then I will upgrade to
1.1.4pr2)
To upload (I'havent ever used interceptors... have I only to copy the .jar and .tld files in WEB.INF???). This is the test file: -------------------------------------------------------------------------------------------------------------------------------------------------- <html> <%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %> <head> <db:base /> <target="_top"> </head> <body> <db:dbform autoUpdate="false" followUp="/tests/testAuthorBooksSubForm_DbSearchCombo.jsp" maxRows="1" tableName="AUTHOR" > <input type="hidden" name="customEvent" value="re_0_0"/> <db:header> <h1 align="center">Edit Authors</h1>
<table class="fixed"
align="center">
<db:errors/> </db:header> <db:body> <db:searchCombo fieldName="AUTHOR_ID" style="width:225px" customEntry=",,true" > <db:queryData name="AUTHOR_ID" query="select distinct AUTHOR_ID, NAME from AUTHOR " /> </db:searchCombo>
<tr
class="even">
<td style="width:300px">ID</td> <td style="width:100px"><db:label fieldName="AUTHOR_ID"/> </td> </tr> <tr class="odd"> <td style="width:300px">NAME</td> <td style="width:300px"><db:textField size="25" fieldName="NAME"/></td> </tr> <tr class="even"> <td>ORGANISATION</td> <td><db:textField size="25" fieldName="ORGANISATION"/> </td> </tr> <tr class="button"> <td colspan="2" style="text-align:center"> <db:updateButton style="width:100" caption="Save"/> <db:deleteButton style="width:100" caption="Delete"/> <db:insertButton style="width:100" caption="Insert" showAlways="false" /> </td> </tr> <tr class="button"> <td colspan="2" style="text-align:center"> <db:navFirstButton style="width:100" caption="<< First"/> <db:navPrevButton style="width:100" caption="< Previous"/> <db:navNextButton style="width:100" caption="> Next"/> <db:navLastButton style="width:100" caption=">> Last"/> <db:navNewButton style="width:100" caption="New" showAlwaysInFooter="false"/> <db:navCopyButton style="width:100" caption="Copy" showAlwaysInFooter="false"/> </td> </tr> <tr> <td colspan="2" style="text-align:center"> <h2>sub form</h2> </td> </tr> <tr><td colspan="2" style="text-align:center"> <db:dbform autoUpdate="false" followUp="/tests/testAuthorBooksSubForm_DbSearchCombo.jsp" maxRows="*" tableName="BOOK_QUERY" parentField="AUTHOR_ID" childField="AUTHOR_ID" orderBy="ISBN" > <db:header> <table> <tr> <td colspan="4"> Subform dbsearch combo <db:searchCombo fieldName="BOOK_ID" style="width:225px" customEntry=",,true" > <db:queryData name="BOOK_ID" query="select distinct BOOK_ID,TITLE from BOOK where TITLE like '%Galaxy%'" /> </db:searchCombo> </td> </tr> </db:header> <db:body allowNew="true"> <tr> <td><db:label fieldName="BOOK_ID"/> </td> <td><db:textField fieldName="ISBN"/> </td> <td><db:textField fieldName="TITLE" /> </td> <td> <db:updateButton style="width:100" caption="Save"/> <db:deleteButton style="width:100" caption="Delete"/> <db:insertButton style="width:100" caption="Insert" showAlways="false" /> </td> </tr> </db:body> <db:footer> <tr class="button"> <td colspan="4" style="text-align:center"> <db:navFirstButton style="width:100" caption="<< First"/> <db:navPrevButton style="width:100" caption="< Previous"/> <db:navNextButton style="width:100" caption="> Next"/> <db:navLastButton style="width:100" caption=">> Last"/> <db:navNewButton style="width:100" caption="New"/> <db:navCopyButton style="width:100" caption="Copy"/> </td> </tr> <table> </db:footer> </db:dbform> </td></tr> </db:body> <db:footer> <tr class="button"> <td colspan="2"> main form form filter: <db:filter> <db:filterCondition label="author name like"> NAME LIKE '%?%' <db:filterValue/> </db:filterCondition> <db:filterCondition label="ID >= V1 AND ID <= V2"> AUTHOR_ID >= ? AND AUTHOR_ID <= ? <db:filterValue label="V1" type="numeric"/> <db:filterValue label="V2" type="numeric"/> </db:filterCondition> <db:filterCondition label="author is"> NAME = '?' <db:filterValue type="select"> <db:queryData name="q1" query="select distinct name as n1, name as n2 from author where AUTHOR_ID < 100 order by name"/> </db:filterValue> </db:filterCondition> <db:filterCondition label="author who write more than N books"> (SELECT COUNT(*) FROM BOOK WHERE BOOK.AUTHOR_ID = AUTHOR.AUTHOR_ID) > ? <db:filterValue type="select" customEntry="10,10,true"> <db:staticData name="p1"> <db:staticDataItem key="1" value="0"/> <db:staticDataItem key="1" value="1"/> <db:staticDataItem key="2" value="2"/> <db:staticDataItem key="3" value="3"/> <db:staticDataItem key="4" value="4"/> </db:staticData> </db:filterValue> </db:filterCondition> <db:filterCondition label="now is after date"> CURRENT_DATE > ? <db:filterValue type="date" useJsCalendar="true" /> </db:filterCondition> <db:filterCondition label="now is after timestamp"> CURRENT_TIMESTAMP > ? <db:filterValue type="timestamp" /> </db:filterCondition> <db:filterCondition label="filter without user input"> AUTHOR_ID > 1 </db:filterCondition> </db:filter> </td> </tr> </table> </db:footer> </db:dbform> </body> </html> --------------------------------------------------------------------------------------------------------------------------------------------------
Many thankx
Ivan *********** REPLY SEPARATOR *********** On 30/11/2003 at 21.27 Henner Kollmann wrote:
>Hi Ivan,
> >dbSearchCombo just builds the whole bunch of select fields for you. It's >the >same like generating filter fields manually. >So this seems to be a problem of filtering in current version. > >Please could you make an example based on the bookstore example to help to >find the problem? >Or do a little bit debugging in the filter code to find the bug? > >Thanks you very much, > >Henner > > >> -----Urspr�ngliche Nachricht----- >> Von: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Im >> Auftrag von Ivan Codarin >> Gesendet: Sonntag, 30. November 2003 21:14 >> An: [EMAIL PROTECTED] >> Betreff: [dbforms] DbSerachCombo >> >> >> Dear All, >> I discovered that dbSerachCombo is very useful! I'm using >> dbforms 1.1.4pr1. But now I have a problem in this kind of situation: >> >> I have a "master dbform" based on "table1" (named >> masterForm). In this dbform I use a dbSearchCombo to restrict >> the records to one search field. >> >> Than I have another nested dbform based on "table2" (named >> detailForm) and there are 2 ParentdFields<->ChildFields bindings. >> >> In the detailForm I have another dbSearchCombo. >> >> My big problem is this: when I use the detailForm >> dbSearchCombo I loose the bindings with the masterForm and in >> the detailForm I see records that aren't binded to the masterForm. >> >> So I need something like a "hierarchical" dbSearcCombo whith >> the first I have to restrict the recordset of the "table1" to >> one type of elements. >> >> Then with the second dbSearchCombo (in the detailForm) I have >> to restrict the records of the nested form to a subset of the >> records of the "masterForm". This isn't working for me. >> >> Many Thanks >> Ivan >> >> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: SF.net Giveback Program. >> Does SourceForge.net help you be more productive? Does it >> help you create better code? SHARE THE LOVE, and help us >> help YOU! Click Here: http://sourceforge.net/donate/ >> _______________________________________________ >> DbForms Mailing List >> >http://www.wap-force.net/dbforms > > > >------------------------------------------------------- >This SF.net email is sponsored by: SF.net Giveback Program. >Does SourceForge.net help you be more productive? Does it >help you create better code? SHARE THE LOVE, and help us help >YOU! Click Here: http://sourceforge.net/donate/ >_______________________________________________ >DbForms Mailing List > >http://www.wap-force.net/dbforms |
