# Valuelist not sorting

**URL:** <https://forum.servoy.com/t/valuelist-not-sorting/7508>\
**Category:** Classic Servoy\
**Created:** [May 15, 2007, 4:09pm UTC](https://forum.servoy.com/t/valuelist-not-sorting/7508 "2007-05-15T16:09:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**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:09pm UTC](https://forum.servoy.com/t/valuelist-not-sorting/7508/1 "2007-05-15T16:09:24Z")

</div>

Hi Guys,  
I’m not sure if this is a bug, my inexperience, or just a limit I’ve bumped into.

If I create a valuelist based on a table in my database and sort the valuelist ascending or descending, it works if I have a small number of records in the database (72 in my test case). If I use it with my development database which has 1771 records in the database then the valuelist only displays a descending sort (even if the sort is ascending). Changing the sort on the valuelist makes no difference.

Any answers would be appreciated - even if I need to redesign the database I inherited.

I also have a reply from Rob Ganselves in the programming forum, to send in a support request, but I’m not sure with this new information whether it is a suppor issue or not.

Thanks  
Graham

---

<div class="post-metadata">

**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:11pm UTC](https://forum.servoy.com/t/valuelist-not-sorting/7508/2 "2007-05-15T16:11:01Z")

</div>

Sorry - I am using Servoy 3.5b4, MySQL 5.0, Java 1.5\_0\_6 on windows XP. The database is using INNODB.

Graham

---

<div class="post-metadata">

**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:48pm UTC](https://forum.servoy.com/t/valuelist-not-sorting/7508/3 "2007-05-15T17:48:40Z")

</div>

Problem solved.

The 500 record limit is the culprit. I created lookup tables for my valuelists that are based on tables, and the problem went away.

Thanks to Rob and Patrick for their input

Graham