Archive of UserLand's first discussion group, started October 5, 1998.

Re: Why is sorting tables limited?

Author:Alan German
Posted:5/3/1999; 12:56:27 PM
Topic:Why is sorting tables limited?
Msg #:5570 (In response to 5565)
Prev/Next:5569 / 5571

So storing the date as a coerced numeric value will cause items in the table to be sorted by time...?

You may want to multiply by -1 to change the sign. You can play other games, too. "number (infinity - date (clock.now())) * -1" produces a number which sorts in reverse chron order.

I've stopped playing those games and taken the hint from the news/dg stuff and started storing things in year/month/day tables. For reverse listings, I just use a "for ctItems downTo 1". Seems to have taken care of most stuff I sort by date.

There are responses to this message:

This page was archived on 6/13/2001; 4:49:44 PM.

© Copyright 1998-2001 UserLand Software, Inc.