User forums now online! Please see the latest post in the Announcements forum for more information.

Author Topic: questions :sorting the database  (Read 517 times)

0 Members and 1 Guest are viewing this topic.

miltk

  • Full Member
  • ***
  • Posts: 64
    • View Profile
questions :sorting the database
« on: 2017-09-17 01:45:30 »
i have all my image files named "rsrc.img (xxxx).jpg  currently up to rsrc.img (4027).jpg

currently i have them sorted as primary:date   secondary:date   descending, because i want the latest additions always at the top.  when i change to "numeric name" or "name", although the latest images are still at the top, there's a slight shuffle

why?

what's the difference between, "name", "numeric name", and "date" and what is the necessity for a secondary sort

Daan van Rooijen

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 831
    • View Profile
questions :sorting the database
« Reply #1 on: 2017-09-17 02:53:17 »
> what's the difference between, "name", "numeric name", and "date"

Name is alphabetic. Numeric Name takes into account the numeric value (rather than alphabetic order) of numbers in the name (e.g. IMG0099 comes after IMG09). Date is chronological.

> what is the necessity for a secondary sort

When the primary key is the same for two files, the secondary key determines the sort order.
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.