"Kinky" sort...

[Ruslan Zasukhin]

On 9/19/05 11:45 AM, "Ton Kuypers" <tkuypers at pandora.be> wrote:

> Hi gang,
> 
> I am out of inspiration, somebody please help me...
> 
> I've got a listbox containing a list of data:
> ID    Description    Group    Date
> 1     text 1         group1   20050104
> 2     text 2         group1   20050104
> 3     text 3         group2   20051004
> 4     text 4         group3   20051004
> 5     text 5         group2   20050104
> 6     text 6                  20050204
> 7     text 7                  20050104
> 8     text 8         group1   20050104
> 9     text 9                  20050204
> 10    text 10        group3   20050104
> 
> The date column is in fact the result of the seconds-function.
> The data is the result of a SQL query to mySQL

Why you not use DBMS itself to produce required sorting ?


Listbox work ok only for small amount of records.

So you can get into trap if some query will return e.g. 100K records or
million 


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]