|
Thanks everyone! Yes the series=> collection thing I was already doing. I get the plugboard => file name prefix idea also (I have a few series where I use 3.5, 3.8 and suchlike for intervening shorts, so I might have to think on that...)
The odd thing is, I can't make ANY sense of the order actually shown. I've wasted a couple of hours now trying various combinations of stuff like:
select content.series, content.seriesnumber, content.dateadded, content.DateLastREad, content.datecreated, shelfcontent.datemodified from ShelfContent, Content where ShelfName="The xxx Series" AND ShelfContent.ContentID = content.ContentID ORDER BY content.dateadded, content.DateLastREad, shelfcontent.datemodified
Sometimes it seems to make sense, but more often I can't work it out at all. It makes me wonder if there is a bug in whatever database runtime they are using on the device?
|