Lars;145325 Wrote:
>
> The problem I have is, that those selections work as I would expect it
> in every query browser (when I put in numbers from the database for the
> {genre} and {album} place holders). But if I uses those querries from
> within the SlimServer I only get weired results. I guess, I did not
> catch one or two important points about how the SlimServer querries
> work ...
I believe the second SQL has incorrect result columns for usage with
CustomBrowse plugin, you will need to change the first row from:
SELECT albums.id, albums.title, tracks.id, tracks.title
To:
SELECT tracks.id, tracks.title
The reason is that CustomBrowse will expect the three first columns to
be:
- Identifier
- Name
- Letter (For letter links in web interface) (This column is optional
and only required if a <menulinks>alpha</menulinks> element exist for
the specific menu.)
So in your case you should be fine by returning the
identifier(tracks.id) and the name(tracks.title) as described above.
--
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://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
