------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.slimdevices.com/showthread.php?t=41597
------------------------------------------------------------------------
Question: Does Album Catalogue Creator (RC5+) create a trustworthy
output?
- Yes
- Yes but with minor issues
- No
- It does not work at all
------------------------------------------------------------------------
'### Iterate through every album by AlbumID
iAlbumID = rs("AlbumID")
sql = "SELECT distinct genres.namesort AS 'Genre' FROM albums "
&_
"left join tracks on tracks.album=albums.id " &_
"left join genre_track on genre_track.track=tracks.id "
&_
"left join genres on genre_track.genre=genres.id " &_
"Where Albums.ID = " & iAlbumID & " " &_
"order by genre;"
Should also be changed to:
'### Iterate through every album by AlbumID
iAlbumID = rs("AlbumID")
sql = "SELECT distinct genres.namesort AS 'Genre' FROM albums "
&_
"left join tracks on tracks.album=albums.id " &_
"left join genre_track on genre_track.track=tracks.id "
&_
"left join genres on genre_track.genre=genres.id " &_
"Where albums.id = " & iAlbumID & " " &_
"order by genre;"
/Kuben72
--
Kuben72
------------------------------------------------------------------------
Kuben72's Profile: http://forums.slimdevices.com/member.php?userid=15308
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
