Have a look at your outputfile and the generated sql statement. Is the order by seen there? Does your ods support order by?
Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von kangi > Gesendet: Freitag, 18. Februar 2005 09:50 > An: [email protected] > Cc: Henner Kollmann > Betreff: [dbforms] why sorting doesn't work > > 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> > ... > > ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
