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>
...
 

Reply via email to