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 Works great! Regards Phil -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal...SB3+Stontronics PSU - Altmann JISCO/UPCI - TACT RCS 2.2X with Good Vibrations S/W - MF X-DAC V3/X-PSU/X-10 buffer (Audiocomm full mods)- Linn 5103 - Linn Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Kimber & Chord cables ------------------------------------------------------------------------ Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=41597 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
