Results 1 to 8 of 8

Thread: Database build question

  1. #1
    Variable Bitrate
    Join Date
    May 2004
    Posts
    335

    Database build question

    How come the music database doesn't pull in alphabetical order? When I observe the files being pulled into the database when I build it in Media Engine, it goes in alphabetical order for a bunch of folders and then does it again for another bunch. So I have a few areas in my music database when I Browse All Music that are A-Z, A-Z, A-Z. I want just one A-Z database.

  2. #2
    Constant Bitrate Ill1's Avatar
    Join Date
    Jun 2004
    Location
    Woodbridge, VA
    Posts
    118
    I believe it is in alphabetical order, but not the way that you want. It is in order by full path name. I don't use ME, so I don't know if there is a way to change it. I remember this being talked about a few months ago, so do a search to see if there is a way to change this.

  3. #3
    Maximum Bitrate
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    597
    I think they go by date, not name... It's just a coincedent that your letters are almost in order with dates.

    Of course, I'm not the one that program this, best chance is to ask him that question.

  4. #4
    Variable Bitrate
    Join Date
    May 2004
    Posts
    335
    Yeah it seems the be by date, but I wonder which date.. I used a program that changes the Created, Modified and Accessed dates on a file all to be the same date and it still puts it in a weird order. I'll keep searching

  5. #5
    Maximum Bitrate phat_bastard's Avatar
    Join Date
    Sep 2002
    Location
    St.Louis, MO
    Posts
    549

    Err that'd be a bug

    I'm glad i caught this thread - I just looked and that particular SQL query is missing ordering clauses which will cause the records to be returned in stupid orders. Fixing....

    Grab 2.2.0 when we release it (sorry no eta) and your ordering should make more sense.
    '01 Chevy Xtreme Stepside (pics)

    FIC K7MNF-64 / Athlon 3200 | 256 DDR | 120 GB 7.2k WD
    WinXP Pro | MediaEngine | 12.1 VGA TFT Touch|Creative CIMR-100
    350w Vector | 320w mATX PS | Hellroaring BIC95150 | ButterflySDC

  6. #6
    Variable Bitrate
    Join Date
    May 2004
    Posts
    335
    great news!! I can't wait!

    Just to verify, how are the mp3s ordered in the database? Date then folder then file name?

  7. #7
    Maximum Bitrate phat_bastard's Avatar
    Join Date
    Sep 2002
    Location
    St.Louis, MO
    Posts
    549
    They're ordered however window's FindFile API returns them to us. On an NTFS filesystem this will be in alpha order, but on the FATs it will be by timestamp. To see it how we get it fed to us do a 'dir /s' from a command prompt and you should see the same ordering. This generally makes no difference to the end user because all of the queries we use to extract info from the database later on use ordering clauses (of course, save this one that you located). For example when you browse in the folders, there's an option to have it sort by filename (which is how I prefer) or by artist-title. Then when you browse by artist then album, it will sort by track number (drawn from the id3 tag). I've found that most ppl have problems understanding why records sort in strange ways, and then they look at their database in access and find out that 80% of their media is incorrectly or incompletely tagged. One of my pet peeves is that 99% of what I listen to gets tagged by some schmuck as genre: 'Rock'. Who on this planet who appreciates their music enough to post the album to freedb would categorize Tool as genre: 'Rock'? But I digress...

    http://www.freedb.org/freedb_search_...ck&id=b712040f
    '01 Chevy Xtreme Stepside (pics)

    FIC K7MNF-64 / Athlon 3200 | 256 DDR | 120 GB 7.2k WD
    WinXP Pro | MediaEngine | 12.1 VGA TFT Touch|Creative CIMR-100
    350w Vector | 320w mATX PS | Hellroaring BIC95150 | ButterflySDC

  8. #8
    Maximum Bitrate
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    597
    Umm... will you add a button that brings to the top of the list? I know the very top of the list is the back to upper folder, but when I'm down a few 100 pages, going back up to switch tree takes forever. Anyway to implement it?

Similar Threads

  1. Does anyone want to build a fiberglass mold?
    By SecretSpyder in forum Fabrication
    Replies: 6
    Last Post: 11-09-2007, 04:10 PM
  2. Replies: 97
    Last Post: 09-18-2006, 01:56 PM
  3. Adding songs to database question
    By tmar89 in forum Media Engine
    Replies: 0
    Last Post: 07-03-2004, 03:40 PM
  4. DVD drive question
    By Pokey in forum Newbie
    Replies: 3
    Last Post: 05-11-2004, 04:26 PM
  5. Database question?
    By jagreen2 in forum Software & Software Development
    Replies: 11
    Last Post: 02-12-2004, 09:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •