This is really trivial to do in SQL.
Max
This is trivial to do in SQL. SQL is a really easy language to pick up
the basics of so it would really be worth your while learning it. Do a
search for SQL Tutorial in Google. In the meantime, here's something
I've just hacked up in a couple of minutes:
Code:
--------------------
select a.title, c.name
from albums a, contributor_album ca, contributors c
where a.id = ca.album
and ca.contributor = c.id
and a.compilation = 0
union
select a.title, 'Various Artists'
from albums a
where a.compilation = 1
order by c.name
--------------------
Max
davep Wrote:
> I would really like to be able to generate up to date lists - excel,
> pdf, etc - of the albums I have in my slimserversql.db. There used to
> be a pearl script which did this but as AFAIK this was before the
> change to the sqlite backend.
>
> I have looked into the db using one or two sqlite front ends and can
> see that the info is there but not in readily accessible form (i.e.
> seperate lists of albums, tracks and contributors but not linked in an
> immediately usable way). I am not really interested in learning SQL
> syntax to construct a way of generating such a list so was wondering if
> anybody else had done such a thing. Goal would ideally be to have a
> complete list of albums, sorted by artist, on my PDA so that it could
> be checked during shopping binges.
>
> davep
--
max.spicer
The wild things roared their terrible roars and gnashed their terrible
teeth
and rolled their terrible eyes and showed their terrible claws
but Max stepped into his private boat and waved good-bye
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
