Home› General support

ascending file order

george2 Member
in General support
i opened this ticket, but don't know what file to look for in ordering the files - any ideas?

http://www.zenphoto.org/trac/ticket/573

Comments

  • acrylian Administrator, Developer
    I guess that would be class-album.php but I actually don't know. Can't you just rename the files...?
  • george2 Member
    i could, but that's not fixing the bug!
  • acrylian Administrator, Developer
    I am not familiar with those code parts, but we will look at that.
  • sbillard Member
    Sorry this is a proper alphabetic sort. If you really want 001, 010, 011..., then you should use those strings when you define the image.
  • jlang Member
    I imagine there are too many possible ways to name files/directories each leading to different "best" sort orders to add anything like this to the standard distribution, although possibly there might be space for a "name, sorted numerically" checkbox/list item.

    If you want to DIY for your particular naming/numbering scheme, a standard way to order alphanumeric fields numerically is to use "ORDER BY CAST(name AS UNSIGNED) ASC" in the sql where name and UNSIGNED etc are set appropriately.
  • macalter Member
    I smile as george2 touched upon a peeve of mine, the alphanumeric ordering. It's not exclusive to ZP, that I know. It's hard to catch because my directories show the files in "perfect" numeric order. Ended up renaming ALL my files to add zeros to overcome the problem.
Sign In or Register to comment.