Re: Sorting by date

[Frank Miedreich <miedreich@acm.org>]

>******    message to minivend-users from Chris Unger <cunger@early.com>
>******
>
>At 06:39 PM 9/2/99 +0200, Frank Miedreich shaped the electrons to say:
>>******    message to minivend-users from Frank Miedreich
>><miedreich@acm.org>     ******
>>
>> >******    message to minivend-users from Chris Unger <cunger@early.com>
>> >******
>> >
>> >
>> >       I would like to reverse sort by date. I use 19990824, 19990830,
>> >19990831
>> >and 19990901 my dates. How would I use minivend to sort these in reverse
>> >order.
>> >       I tried [sort products:code:nr], but this doesn't work.
>> >
>> >       Any ideas?
>> >
>>
>>As it seems unlikely that the date really is the key for your products
>>table, I suggest you [sort products:date:nr]. If you actually do use a date
>>as the key, [sort products:0:nr] might work.
>
>         Well, the field name is code, But changing sort products:code:nr
>to sort products:0:nr does not work either
>
>

I just checked a site where I initially started with a similar scheme for
news items, which initially used a date as code. I introduced a field date
into the database, and sorted by date. This might be the easiest way.

Otherwise, if the sort is for an in-page search, you could sort the results
from the search with perl.

I seem to remember a similar discussion on the list some time ago, maybe it
would be worth while to check the list archives.

Good luck, Frank

--
Frank Miedreich
Max-Planck-Institut fuer psychologische  Forschung
Leopoldstr. 24   80802 Muenchen   +49 89 38602-237