|
hi,
i have one field called id which is a primary key and
sortable, i want to sort records by this field, but why it doesn't work, the
following is the slice of my dbform-config.xml and jsp page:
dbform-config.xml
....
<table
name="ODS_CUSTOMER"
defaultVisibleFields="NAME" > <field name="ID" fieldType="number" size="18" isKey="true" sortable="true"/> <field name="OID" fieldType="number" size="18"/> <field name="NAME" fieldType="varchar2" size="2000"/> <field name="ADDRESS" fieldType="varchar2" size="2000"/> <field name="ABBREVCN" fieldType="varchar2" size="2000"/> <field name="CONTACTORNAME" fieldType="varchar2" size="2000"/> <field name="ABBREVPY" fieldType="varchar2" size="2000"/> <field name="PHONE" fieldType="varchar2" size="2000"/> <field name="FAX" fieldType="varchar2" size="2000"/> <field name="EMAIL" fieldType="varchar2" size="2000"/> <field name="OLDNAME" fieldType="varchar2" size="2000"/> <field name="REGIONID" fieldType="number" size="18"/> <field name="NO" fieldType="varchar2" size="2000"/> <field name="BANK" fieldType="varchar2" size="2000"/> <field name="COUNT" fieldType="varchar2" size="2000"/> <field name="FILENO" fieldType="varchar2" size="2000"/> <field name="PARENTCUSTOMERID" fieldType="number" size="18"/> <!-- add "granted-privileges" element for
security constraints -->
</table>
.....
ODS_CUSTOMER_list.jsp:
...
<db:dbform multipart="false"
autoUpdate="false" followUp="/ODS_CUSTOMER_list.jsp" maxRows="*"
tableName="ODS_CUSTOMER" orderBy="NAME">
<db:header> <db:errors/> <table align="center" > <tr class="clsHeaderDataTableRow"> <td><db:sort fieldName="ID"/></td> ...
|
- AW: [dbforms] why sorting doesn't work kangi
- AW: [dbforms] why sorting doesn't work Henner Kollmann
