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
> -----Urspr�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
