1 Reply Latest reply on Jun 30, 2002 2:06 PM by Dain Sundstrom

    how do i alphabetically order the list of records ?

    karthikeyan Newbie

      I have a column called user id where names are stored as strings, i want to query them so that i get the list of records arranged alphabetically (i.e. the alphbatical order of user names,the primary key also happens to b the userid).I tried modifying the jaws.xml by giving in as follows ,but no change any ideas?


      oraclepool
      <type-mapping>Oracle8</type-mapping>
      <enterprise-beans>

      <ejb-name>IMFriendlistBean</ejb-name>
      <table-name>TANGO_IM_FRIENDLIST</table-name>
      <cmp-field>
      <field-name>keyfield</field-name>
      <column-name>KEYFIELD</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>Tango_Userid</field-name>
      <column-name>TANGO_USERID</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>Groupid</field-name>
      <column-name>TANGO_GROUPID</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>Friendid</field-name>
      <column-name>TANGO_FRIENDID</column-name>
      </cmp-field>
      <!-- JBoss 2.4

      -->

      findByPrimaryKey
      <![CDATA[(= 1 1)]]>
      Tango_Userid



      </enterprise-beans>


      Tango_Userid is the column name, iwant to it to b retrieved fro m db in alphabetical order