street_samurai Wrote: > Basically I just want a listing of all my Albums by Artist with the year > field. I know this could be tricky for Various Artists albums but it > doesn't seem that difficult. > > Anyone seen software that can do this? > > ss.
Here's the approximate SQL you need to get this sort of listing: select contributors.name, albums.title, albums.year from albums, contributors where albums.contributor = contributors.id order by contributors.name, albums.year; If you can get my DirectPlayBook.pl script working, you can just remove the existing SQL statements and replace them with this one to get the listing that you are looking for. -- jth ------------------------------------------------------------------------ jth's Profile: http://forums.slimdevices.com/member.php?userid=48 View this thread: http://forums.slimdevices.com/showthread.php?t=18804 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
