Album sorting

**TSXPC** · 12-08-2006, 09:49 AM

I have recently started using WMP11 on my desktop pc and really like the way the albums are sorted. When selecting albums it shows the art however instead of the albums in alphabetical order they are catagorized with the first letter of the band name and then in alphabetical order by album name. Would it be possible to set up centrafuse the same way, I know we can search by Artist however I have several albums with various artists and it lists each artist individually instead of showing the entire album.

**veetid** · 12-08-2006, 10:24 AM

Originally Posted by TSXPC

I have recently started using WMP11 on my desktop pc and really like the way the albums are sorted. When selecting albums it shows the art however instead of the albums in alphabetical order they are catagorized with the first letter of the band name and then in alphabetical order by album name. Would it be possible to set up centrafuse the same way, I know we can search by Artist however I have several albums with various artists and it lists each artist individually instead of showing the entire album.

if you know Access this would be very easy to change... I do not recommend this for anyone that doesn't know what they are doing because they will break the application...

All queries are done with SP's in the Access database main.dat, if you open it and go to the Queries section, find the Album Queries, change their order by statements...

david

**justintime** · 12-08-2006, 11:07 PM

INSTRUCTIONS

1) BACKUP YOUR MAIN.DAT FILE.

2) Open the main.dat file with Microsoft Access, and then click on QUERIES icon. Locate the query called GetAlbums, and right-click->DesignView.

3) Make sure it now displays the SQL view by going to VIEW menu, and selecting SQL View.

4) Now paste this:

SELECT Left([artist],1)+" - "+[album] AS Expr2, Min(id3.filename) AS MinOffilename, [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album]) AS Expr1
FROM id3
GROUP BY Left([artist],1)+" - "+[album], [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album])
ORDER BY [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album]);

5)Save and exit.

**TSXPC** · 12-10-2006, 06:03 PM

Thanks justintime the albums are sorting the way I like them now however when you select an album no songs are showing up in the playlist? Any idea what is happening there?