PasTim wrote:
> When you say it doesn't work, what precisely happens? Do you get an
> error, or just nothing back? If LIKE '%PARTY%' works, then assuming
> this is standard SQL the OR LIKE ... should also work. Are there error
> messages in the LMS log? Other syntaxes might work (eg using the IN
> keyword). I haven't be able to try this myself as yet.
It is working now, heres the complete sql text, which works in Erlands
great Plugin SQL Playlist:
-- PlaylistName:DANCE PARTY
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join albums on
tracks.album=albums.id and
albums.title LIKE '%DANCE%'
OR
tracks.album=albums.id and
albums.title LIKE '%PARTY%'
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by random()
limit 10;
Thank you for the right hint!
Regards
Pommes
The Earth Has Music For Those Who Listen
------------------------------------------------------------------------
Pommes's Profile: http://forums.slimdevices.com/member.php?userid=67682
View this thread: http://forums.slimdevices.com/showthread.php?t=109825
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
