Philip Meyer Wrote: > The comment "param 1: playlist" could be interpretted by SQL Playlist > plugin such that the plugin would know to prompt the user to select a > valid playlist (ie. on the Player UI line 1 could read "Select a > playlist..." and line 2 would be used to select a known static playlist > using cursor keys). Ok now I think I understand what you meant with enumeration, you where just saying that the user should be able to select among all objects of the type, for example all playlists.
Maybe it would be a good idea to be able to define a SQL for the enumeration besides just the type ? This would make it possible to limit the selection list, for example just showing all playlists that contains tracks with a specific genre or something. In the playlist example this is probably not so useful, but it might be useful in other situations. Philip Meyer Wrote: > Perhaps an even better way would be to make the SQL files contain stored > procedures. I guess MySQL supports stored procedures, and that it is > capable to dynamically determine the parameters that are expected for a > stored procedure? MySQL supports stored procedures starting with MySQL 5.0, this also means that it will work with the default MySQL installation delivered with slimserver 6.5. However, at the moment I would like the functionallity to work with slimserver 6.2 with SQLite since that is the version most people use. So I think it might be a good idea to start with a plain SQL solution and then extend it to also support stored procedures in a later release. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://tinyurl.com/pptqy) , 'DynamicPlayList' (http://tinyurl.com/kfrgs) and 'RandomPlayList' (http://tinyurl.com/pwtsc) plugins) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=24700 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
