max.spicer Wrote: > Seemingly random list of albums? Odd! On my system it outputs a > complete list of all my albums, sorted by artist. > > Max
Max, I have tried this several times undser both Linux and Windows using a variety of tools and get the same NOT random selection of 13 albums by 8 artists. Digging into my db I see that the table contributor_album has the same size and shape as this output data and I suspect this is the cause. I do not understand it though as I imagine that this index should reflect the whole 700+ albums in the db - which are all clearly visible in the albums index, as are the 300 odd artists in the contributors index. Could this be a tagging thing? Anyway I got what I wanted by doing a kludge in excel using two csv tables - one for albums with contributor id and the other a list of contributors and using a VLOOKUP to marry the two into my final list. Thaks for your help which got me started playing with SQL syntax. davep -- davep _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
