iballan;336014 Wrote: > Thankyou for the quick support. I might be a bit demanding on this one. > But i don't really like the idea of multiple libaries. I've been > looking at the dokumnetation, and it looks like the is a possibility to > make a sql query like > > SELECT * where path=%\Artists%
If you want to manually modify the SQL statements, that is possible, in that case you should add strings like "url like %\\Artists%" everywhere. Also note that spaces are encoded as %20, so I think you for Various Artists need to use something like "url like %\\Various%20Artists%". The %20 in the middle is probably not interpreted completely correct, it might work with \%20 but I'm not completely sure. This only works in SQL statements that includes the tracks table, if the tracks table isn't included you will have to add additional joins. I'm not sure if tracks table is part if all queries used in the above mentioned menus, if it is it might be pretty easy to add "url like" statements. If it isn't I would avoid this route unless you are very familiar with SQL. However, you should also be aware of that using "like" directive like this might result in bad performance if your library is large. In a small library it will probably work, but in a large library I strongly suspect that using the Multi Library plugin which does most of the work during scanning will get you increased performance. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=51916 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
