Could you try to define CATEGORY_ID as a field? Cheers, Henner
> -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Dziugas Baltrunas > Gesendet: Mittwoch, 4. August 2004 15:01 > An: dbf interest > Betreff: [dbforms] query and gotoPrefix question > > Hi list, > > I have a following definition in my dbforms-config.xml: > > <query name="documents" > from="HC_DOCUMENT, HC_DOCUMENT_TO_CATEGORY" > where="HC_DOCUMENT.ID = HC_DOCUMENT_TO_CATEGORY.DOCUMENT_ID" > > <field name="ID" fieldType="number" > expression="HC_DOCUMENT.ID"/> > <field name="TITLE" fieldType="varchar2" > expression="HC_DOCUMENT.TITLE"/> > <search name="CATEGORY_ID" fieldType="number" isKey="true" > expression="HC_DOCUMENT_TO_CATEGORY.CATEGORY_ID"/> > </query> > > I would like to use gotoPrefix in order to filter rows with given > CATEGORY_ID: > > <db:dbform autoUpdate="false" followUp="/documents_list.jsp" > maxRows="10" tableName="documents" gotoPrefix="fv_"> > > However, accessing /documents_list.jsp?fv_CATEGORY_ID=123 > does not change the query: > > 80059430 [http-8080-Processor3] DEBUG > org.dbforms.taglib.DbFormTag - fieldName=CATEGORY_ID > 80059430 [http-8080-Processor3] DEBUG org.dbforms.taglib.DbFormTag - > fieldValue=123 > ... > 80059470 [http-8080-Processor3] INFO org.dbforms.config.Query > - doSelect:SELECT HC_DOCUMENT.ID ID, HC_DOCUMENT.TITLE TITLE > FROM HC_DOCUMENT, HC_DOCUMENT_TO_CATEGORY WHERE ( > HC_DOCUMENT.ID = HC_DOCUMENT_TO_CATEGORY.DOCUMENT_ID ) > > What am I doing wrong? Are there some other ways to get the > expected behaviour? > > regards, > Dziugas Baltrunas > > > > ------------------------------------------------------- > This SF.Net email is sponsored by OSTG. Have you noticed the > changes on Linux.com, ITManagersJournal and NewsForge in the > past few weeks? Now, one more big change to announce. We are > now OSTG- Open Source Technology Group. Come see the changes > on the new OSTG site. www.ostg.com > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
