Hi,
thanks for your help. I just ran the testAuthorBooksSubForm.jsp from the
bookstore application by deploying the latest "war" file and I obtain
the following. It is different from your results (the ordering is not as
expected). Are we both using the same version ?
dbForm tag in the src:
<db:dbform
autoUpdate="false"
followUp="/tests/testAuthorBooksSubForm.jsp"
maxRows="*"
tableName="BOOK"
parentField="AUTHOR_ID"
childField="AUTHOR_ID"
orderBy="ISBN"
>
The executed select statement:
[org.dbforms.config.Table.getSelectQuery(Table.java:1751)]-::getSelectQuery - [SELECT
BOOK_ID, ISBN, AUTHOR_ID, TITLE FROM BOOK WHERE ( ( ( AUTHOR_ID = ? ) ) )
ORDER BY BOOK_ID,AUTHOR_ID]
regards,
Jitu
On Mon, 2004-08-16 at 16:22, Henner Kollmann wrote:
> Just tested this with bookstore/test/testBOOKSList.jsp:
>
> <db:dbform
> multipart="false"
> autoUpdate="false"
> followUp="/tests/testBOOKSList.jsp"
> maxRows="*"
> tableName="BOOK"
> orderBy="ISBN DESC"
> >
>
> [SELECT BOOK_ID, ISBN, AUTHOR_ID, TITLE FROM BOOK ORDER BY ISBN DESC]
>
> So in bookstore example it works as you expected.
>
>
> Also subforms are working:
>
> <db:dbform
> autoUpdate="false"
> followUp="/tests/testAuthorBooksSubForm.jsp"
> maxRows="*"
> tableName="BOOK"
> parentField="AUTHOR_ID"
> childField="AUTHOR_ID"
>
> orderBy="ISBN DESC"
> >
> [SELECT BOOK_ID, ISBN, AUTHOR_ID, TITLE FROM BOOK WHERE ( ( ( AUTHOR_ID = ? )
> ) ) ORDER BY ISBN DESC]
>
> Regards,
> Henner
>
>
> > -----UrsprC<ngliche Nachricht-----
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Im
> > Auftrag von jitu
> > Gesendet: Montag, 16. August 2004 16:45
> > An: [EMAIL PROTECTED]
> > Betreff: [dbforms] Re: orderBy in dbform tag bug
> >
> >
> > Hi,
> >
> > Sorry for the confusion. I was referring to the problem
> > reported by Dziugas Baltrunas on 2004-08-03.
> >
> > Nevertheless here is an example,
> >
> > database details:
> >
> > create table ledger
> > (
> > ledg_code char(2) not null,
> > userid char(8) not null,
> > accid char(16) not null,
> > tt char(8) not null,
> > jn_type char(4) not null,
> > batch_ref char(16),
> > ap_yy char(4) not null,
> > ap_pp char(2) not null,
> > td date not null,
> > vd date not null,
> > tt_ref char(16),
> > due_date date,
> > jn integer not null,
> > jn_ln smallint not null,
> > srcjn integer not null,
> > srcjn_ln smallint not null,
> > c_code char(8) not null,
> > other_amt decimal(16,2),
> > conv_rate decimal(10,6) not null,
> > ledg_amt decimal(16,2) not null,
> >
> > .................
> > ...............
> > );
> >
> >
> > create unique index ixuledger on ledger (jn,jn_ln);
> > create index ixledger on ledger (ledg_code, accid,
> > jn,jn_ln);
> > create index ...............
> >
> >
> > dbForms-config entry:
> >
> > <table name="ledger">
> > <field name="ledg_code" fieldType="char" size="2" isKey="true"/>
> > <field name="userid" fieldType="char" size="8"/>
> > <field name="accid" fieldType="char" size="16" isKey="true"/>
> > <field name="tt" fieldType="char" size="8"/>
> > <field name="jn_type" fieldType="char" size="4"/>
> > <field name="batch_ref" fieldType="char" size="16"/>
> > <field name="ap_yy" fieldType="char" size="4" sortable="true"/>
> > <field name="ap_pp" fieldType="char" size="2" sortable="true"/>
> > <field name="td" fieldType="date" size="4" sortable="true"/>
> > <field name="vd" fieldType="date" size="4"/>
> > <field name="tt_ref" fieldType="char" size="16"/>
> > <field name="due_date" fieldType="date" size="4"/>
> > <field name="jn" fieldType="int4" size="4" isKey="true"/>
> > <field name="jn_ln" fieldType="int2" size="2" isKey="true"/>
> > <field name="srcjn" fieldType="int4" size="4"/>
> > <field name="srcjn_ln" fieldType="int2" size="2"/>
> > <field name="c_code" fieldType="char" size="8"/>
> > <field name="other_amt" fieldType="numeric" size="16"/>
> > <field name="conv_rate" fieldType="numeric" size="10"/>
> > <field name="ledg_amt" fieldType="numeric" size="16"/>
> >
> > .....................
> > ....................
> > </table>
> >
> >
> > dbform Tag.
> >
> > <db:dbform multipart="false" autoUpdate="false"
> > followUp="/accEnq.jsp" maxRows="*" tableName="ledger"
> > parentField="accid" childField="accid"
> > dbConnectionName="chormit" sqlFilter=" ap_yy = (select
> > current_ap_yy from compid) " orderBy="td">
> >
> > This is what dbForms uses:
> > 13770138 [http8084-Processor22] INFO
> > org.dbforms.config.Table - ::getSelectQuery - [SELECT
> > ledg_code, userid, accid, tt, jn_type, batch_ref, ap_yy,
> > ap_pp, td, vd, tt_ref, due_date, jn, jn_ln, srcjn, srcjn_ln,
> > c_code, other_amt, conv_rate, ledg_amt,...... FROM ledger
> > WHERE ( ap_yy = (select current_ap_yy from compid) ) AND
> > ( ( ( accid = ? ) ) ) ORDER BY ledg_code,accid,jn,jn_ln]
> >
> >
> > Comments:
> >
> > What I required was sorting by "td". Using the same table
> > definitions, I should be able to order and filter differently
> > in different "jsp"s.
> >
> >
> > regards,
> > Jitu
> > On Mon, 2004-08-16 at 12:45, jitu wrote:
> > > I have encountered the same problem with sorting. The
> > orderBy clause
> > > in the dbForm tag is superseded by the "order by" clause that is
> > > worked out dynamically at run time. This (overriding) uses the keys
> > > specified in the dbconfig. The key fields are appended by doing a
> > > search from the beginning of the table definition. This
> > obviously does
> > > not result in actual ordering defined at database level for
> > the table
> > > concerned either.
> > >
> > > It would be useful if the Dbform specifications can override the
> > > dbconfig definitions.
> > >
> > > Is there a solution ?
> > >
> > > regards,
> > > Jitu
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on
> > Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic
> > DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free
> > Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > DbForms Mailing List
> >
> > http://www.wap-force.net/dbforms
> >
>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> DbForms Mailing List
>
> http://www.wap-force.net/dbforms
>
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
