bklaas;151698 Wrote: > FWIW...just from a short time poking around, this is the SQL to produce > a list of artists and albums, sorted by artist, then album: > > select contributors.name, albums.title from albums, contributors where > contributors.id = albums.contributor order by contributors.name, > albums.title; > > Personally, I see a slimserver database reporting tool as residing > separately from slimserver--IMO, this kind of thing doesn't seem right > integrated directly into slimserver. If I was doing this (and I just > might), I'd write a small suite of Perl scripts to generate reports > using DBI and Template::Toolkit. > > Maybe it could be integrated as a plugin, but I guarantee that an > autonomous reporting program could be whipped together with much less > effort... > > cheers, > #!/ben
Ben You're right. A reporting tool doesnt really need to be integrated. I'm just after an easy life, and want a button to press within the Slimserver web interface. (I'll have to dust off my SQL skills - I tried your query in SQLYog- I cant see an albums.contributor field. Nigel -- NigelC ------------------------------------------------------------------------ NigelC's Profile: http://forums.slimdevices.com/member.php?userid=2101 View this thread: http://forums.slimdevices.com/showthread.php?t=29282 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss