> Now i have no idea where to start to find the sqlite database but > will have a go if anyone has done it a few pointers would be > helpfull. (i use a nix box running cent os)
Never heard of that one... If you can find an sqlite (version 3) package for your OS, install that. Once you've done so, here's a script to retrieve a simple list of artist/album/song-title/genre: .mode html select c.name, a.title, t.title, g.name from albums a, tracks t, genres g, genre_track gt, contributors c where t.age > 0 and a.id = t.album and g.id = gt.genre and t.id = gt.track and c.id = a.contributor order by 1,2; (I'm actually building this query in a shell-script, and using the 'age' column a bit differently, but if you want everything, the above works) With the .mode option, you can specify: csv, column, html, insert, line, list, tabs, tcl. -- Maditude ------------------------------------------------------------------------ Maditude's Profile: http://forums.slimdevices.com/member.php?userid=426 View this thread: http://forums.slimdevices.com/showthread.php?t=19484 _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
