usbethjim wrote: > _Here's_the_thing_-_Every_album_I_have_has_an_\"ARTIST_SORT\"_tag:_ > > Bob Dylan's is "Dylan, Bob" - he show's up in the D's not the B's as > "Bob Dylan" in LMS listings. > > Led Zeppelin's is "Led Zeppelin" - they show up in the L's as "Led > Zeppelin" in LMS listings. > > So any SQL query would have to use the same logic. > > Is this a simple thing to do? > Jim
I don't use ARTIST SORT tags myself, so I can't really tell for sure whether this will give you what you want. But you can give it a try, and let me know. In the query you're using (Albums by Artist, or any of the others), find where it says: CO.NAME and change it to CO.NAMESEARCH If that works for you, change any of the other queries you use in the same way, and save the modified Extracts into a file you can re-use (described in the documentation). That way you won't have to go in and edit the query every time. Please let me know whether that works for you or not. There are a lot of different ways people use their systems and tags, and a therefore a lot of different ways to query the database, and I certainly don't have any real expertise on how that data is organized and used. I found some things that work for me, but as your case shows, some tweaks will be needed to make it work the way others use their system. I think it's flexible enough to make those tweaks possible, but knowing what tweaks to make is another matter, and in this case I'm just taking a guess. Thanks for letting me know you've tried the program, and I'm sure we can find the tweaks you need, even if it takes a little trial-and-error. ------------------------------------------------------------------------ Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883 View this thread: http://forums.slimdevices.com/showthread.php?t=101600 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
