Hi,
I made a number of custum browse menu items based on the Filtered
Album custom browse example, filtering on a term in the comment field.
The menu items return a properly filtered list of albums, but when I
chose "sort by artist" from the pull-down menu I get the following
error:
Error:
Running: select albums.id,concat(albums.title, ' (', contributors.name
,')') from tracks,albums,contributor_track,contributors,comments where
tracks.id=contributor_track.track and contributor_track.role in (1,5)
and contributor_track.contributor=contributors.id and and
tracks.id=comments.track and comments.value='female' and
albums.id=tracks.album group by albums.id order by
contributors.namesort asc,albums.year desc got error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'and
tracks.id=comments.track and comments.value='female' and albums.' at
line 6
What am I doing wrong? Any way to make it sort by artist by default?
Also, on the options page for these menus I made there is a check box
called "check include comment for sub strings" What does this do?
On another note: I've followed the discussion here recently how to use
the Genre/sub genre example to browse thru sub-genres. Do I understand
correctly that to implement this you would list multiple stings
separated by ";" in the genre tag field? Could I instead implement a
similar thing but based on multiple strings in the Comment tag? I use
iTunes which doesn't allow multiple genres, but does allow access to
the comment field.
Finally, how does the genre/sub-genre browse look? Suppose I browse to
genre=jazz, do I get a list of available sub-genres as well as all the
albums (or artists) that belong to the genre jazz? Or do I only get
the sub-genres, forcing me to pick one before I see a list of albums?
(I can't test since I don't have multiple entries in my genre tags!)
What I'd like to be able to do is browse to a top level genre and get
all the albums (or artists) that match, but be able to further browse
to sub-genres to narrow the list if I wish.
Thanks. I already love Custom Browse, just with what little I've been
able to do so far!
-Steve
--
wnshall
------------------------------------------------------------------------
wnshall's Profile: http://forums.slimdevices.com/member.php?userid=5886
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
