Frank, Thanks for your response. I'll try and sort out the tagging issue on my own - if I can't figure it out, I'll post a screenshot of the tags.
I was indeed running RC3 instead of RC3a - after upgrading, it fixed the Various Artists issue. I changed the code to sort by AlbumTitle, thanks for providing that. And I found the code that Phil posted with regards to the leading "The": ------- Frank - cracked the "The " problem... two blocks of code changes: 1): sQBase = "select IF ( LEFT( contributors.name, 4)='The ', SUBSTRING(contributors.name FROM 5), contributors.name) AS sort_name, " &_ "CONVERT(contributors.name USING utf8) as artist,CONVERT(albums.title USING utf8) as album,albums.year AS year, tracks.url AS filepath, tracks.tracknum AS tracknumber, " &_ "CONVERT(tracks.title USING UTF8) as tracktitle,CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as duration, genres.namesort AS 'genre' " &_ "from tracks " &_ 2): If iSortby = 1 then sQOrderBy = "order by sort_name,year,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;" Elseif iSortby = 2 then sQOrderBy = "order by lcase(convert(albums.titlesort using utf8)),sort_name,tracks.disc,tracks.tracknum;" Else sQOrderBy = "order by genre,sort_name,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;" End If ---- but I don't know where to insert and or/replace it... Thanks again! -- venus light ------------------------------------------------------------------------ venus light's Profile: http://forums.slimdevices.com/member.php?userid=10916 View this thread: http://forums.slimdevices.com/showthread.php?t=41597 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
