Phil Leigh;254962 Wrote:
> Frank - yes the output is excellent - many thanks for all of your hard
> work.
> I've made a couple of tweaks...
> 1) For compilations - but not normal albums it's nice to have the
> artist next to the track
> 2) for the durations, I've removed the leading zero which makes it
> easier to read (for me anyway)
>
> If Left(rs("duration"),2) = "00" Then
> sDuration = Right(rs("duration"), 5)
> Else
> sDuration = rs("duration")
> End If
> If left(sDuration,1)="0" Then
> sDuration = Right(sDuration,4)
> End If
> If iType = 2 Then
> sTracklisting = sTracklisting & rs("tracknumber") & " - " &
> rs("tracktitle") & " (" & sDuration & ")" &" - " & rs("artist")
> Else
> sTracklisting = sTracklisting & rs("tracknumber") & " - " &
> rs("tracktitle") & " (" & sDuration & ")"
> End If
> iTotalNumberOfTracks = iTotalNumberOfTracks + 1
> iNumberOfTracks = iNumberOfTracks + 1
>
> 3) I've changed the album sort order to be year within artist which is
> the way (I think) most people organise their collections?
> sQOrderBy = "order by artist,year,lcase(convert(albums.titlesort using
> utf8)),tracks.disc,tracks.tracknum;"
Good comment. Escpecially (1). That is how it should be. I'll change it
too in my code for next releases.
Phil Leigh;254962 Wrote:
> The last piece of the jigsaw for me is to get the sort order for artists
> to ignore "The" so that "The Hollies" is under "H" not "T"...I'm not
> quite sure how to do that.
I have been thinking about how to do this. I think the easiest way is
to create a so called 'disconnected recordset' (a new recordset, not
connected to the database but only available inside the code. This
recordset can be used to copy all content of the database query to but
without the keywords to be stripped ('The' etc).
After this one can apply all sorting options on the disconnected
recordset like you normally can.
It should be better to do all this direct from the query to the
database and hence without the disconnected recordset but my SQL
knowledge is not that good to determine if this is possible to do in
query.
Frank
--
SilverRS8
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=41597
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
