sand wrote:
> Hi, this must be out there somewhere, I just cant find it.. sorry! I
> want to decode the tracks.url how do i do that?
> The reason is that I want to exclude a path from my SQLPlaylist
> playlist, and I think that is the way to do it(?)
> Thank's in advance
>
If you want to exclude a path and not an individual file, you should
probably use a like statement.
The path's are stored as urls in the database and are url encoded:
http://meyerweb.com/eric/tools/dencoder/
To see the exact syntax, it's probably easiest to use Database Query
plugin and create a Free form query like:
select url from tracks where url like '%jazz%album1%my best song%'
% is wildcard and the above will match a file like:
/mnt/music/jazz/artist1/album1/1. my best song.mp3
If you don't get it to work, post how the path you want to exclude looks
like and I'll help you create the right query.
When using the path in SQL Playlist, it's important to use a "not like"
criteria and end it with %, for example a criteria like:
Code:
--------------------
tracks.url not like '%jazz%album1%my best song%'
--------------------
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
You may also want to try my Android apps 'Squeeze Display'
(https://play.google.com/store/apps/details?id=info.isaksson.squeezedisplay)
and 'RSS Photo Show'
(https://play.google.com/store/apps/details?id=info.isaksson.rssphotoshow)
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=101106
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
