# sorting Valuelist in 3.5b3 **URL:** \ **Category:** Classic Servoy\ **Created:** [May 11, 2007, 4:31pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489 "2007-05-11T16:31:36Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![gmountain](https://avatars.discourse-cdn.com/v4/letter/g/9fc29f/32.png) [@gmountain](https://forum.servoy.com/u/gmountain)\ **Post date:** [May 11, 2007, 4:31pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/1 "2007-05-11T16:31:36Z")
Hi Guys, I am creating a valuelist in 3.5b3 using a dabase table to provide the data. I have a combobox that is checked to sort the data. No matter whether I put ascending or descending for the sort, the data is always showing as descending. Any ideas on what I’m doing wrong? Servoy 3.5.b3 Mysql 5.0.24 Java 1.5.0\_06 Thanks Graham ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [May 14, 2007, 6:18am UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/2 "2007-05-14T06:18:00Z")
Graham, The sorting is defined on the value list, not on the combo box. Rob ---
**Author:** ![gmountain](https://avatars.discourse-cdn.com/v4/letter/g/9fc29f/32.png) [@gmountain](https://forum.servoy.com/u/gmountain)\ **Post date:** [May 14, 2007, 4:32pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/3 "2007-05-14T16:32:18Z")
Hi Rob, Thanks for replying. I sorted on the valuelist, by clicking on the sort button at the bottom of the valuelist. I have the show in field list button clicked for dept, and return in dataprovider clicked for the same field. No matter whether I change the valuelist to sort asc or desc on that field, it sorts descending. These are valuelists that have worked since servoy 2 Is it just my setup with mysql? Thanks Graham ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [May 15, 2007, 6:06am UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/4 "2007-05-15T06:06:47Z")
Graham, Try the latest 3.5 (beta4) Servoy version. If it still does not work, please create a case in our support system, make sure to include a small sample solution. Rob ---
**Author:** ![MSibai](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@MSibai](https://forum.servoy.com/u/MSibai)\ **Post date:** [May 15, 2007, 7:15am UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/5 "2007-05-15T07:15:32Z")
> Try the latest 3.5 (beta4) Servoy version. I have the same even in 3.5b4 ---
**Author:** ![gmountain](https://avatars.discourse-cdn.com/v4/letter/g/9fc29f/32.png) [@gmountain](https://forum.servoy.com/u/gmountain)\ **Post date:** [May 15, 2007, 3:58pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/6 "2007-05-15T15:58:11Z")
Hi Rob, Ok - maybe it’s the gremlins - I created a new database, 72 records in all, created a small table with lastname, dept and dept2 on a new form - created a valuelist on all three, sorted asc and desc and the valuelist sorts as it is supposed to. Everything works on the sample solution. I go back to my development solution (1771 records) - remove and add the fields to the form, create new valuelists sort as I did on the sample solution and I get a descending sort each time. Even if I change it to ascending. I go back to my sample solution, drop the table and create a table with 3 fields and 1771 records, and lo and behold, the sort is descending, even with the valuelist set to ascending. I’ll send in a support request along with the sample solution. This happens in 3.5b4. Graham ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 15, 2007, 4:11pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/7 "2007-05-15T16:11:43Z")
Aren’t value lists limited to 500 entries? Maybe that’s where the sorting then goes wrong… ---
**Author:** ![gmountain](https://avatars.discourse-cdn.com/v4/letter/g/9fc29f/32.png) [@gmountain](https://forum.servoy.com/u/gmountain)\ **Post date:** [May 15, 2007, 4:39pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/8 "2007-05-15T16:39:18Z")
Hi Patrick, Thanks for the reply. It seems that you are correct. If that limitation is there, then I will have to create a lookup table on all the valuelists I have, since I can no longer use the fields in a single database, since I easily hit that limit. The joys of taking a Filemaker flatfile and trying to work with the result in a relational database. Graham ---
**Author:** ![gmountain](https://avatars.discourse-cdn.com/v4/letter/g/9fc29f/32.png) [@gmountain](https://forum.servoy.com/u/gmountain)\ **Post date:** [May 15, 2007, 5:46pm UTC](https://forum.servoy.com/t/sorting-valuelist-in-3-5b3/7489/9 "2007-05-15T17:46:35Z")
Thanks Patrick and Rob, The problem was solved by creating lookup tables with less than the 500 record limit. A good thing to know. Graham