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
