Hi Erland, appreciate your help, but the solution was a bit more effort
than made sense. I've gone back to iTunes for this particular type of
playlisting- doesn't sound as good as my TP, but it's far more
straightforward to create a simple smart playlist.
cheers/netchord
--
netchord wrote:
> so, this worked for a while, until it didn't, and suddenly most of my
> playlists, SQL or otherwise (created in iTunes) disappeared. full
> rescan, didn't comeback. uninstalled Dynamic, SQL playlists, and
> trackstat, rescan, all is back to normal.
>
Can you reproduce it ?
Di
so, this worked for a while, until it didn't, and suddenly most of my
playlists, SQL or otherwise (created in iTunes) disappeared. full
rescan, didn't comeback. uninstalled Dynamic, SQL playlists, and
trackstat, rescan, all is back to normal.
---
thanks- will test it out. adding these 3 plugins (TS, DP, SQL) seems to
slow down my server significantly, and i hear a fair amount of activity
on the external drive (Drobo) where my music is stored. is this to be
expected?
-
netchord wrote:
> ok, that seems to work. and the "limit 10" in the last line specifies
> the number of tracks in the playlist? will it update dynamically to
> include additional tracks if i let it play? any harm in increasing the
> number of tracks?
>
It's just how many tracks it adds each t
ok, that seems to work. and the "limit 10" in the last line specifies
the number of tracks in the playlist? will it update dynamically to
include additional tracks if i let it play? any harm in increasing the
number of tracks?
--
You can't put the extra statements at the end, they need to be inserted
in the right places, so you need to put them as I specified in the
sample, in your case it would be:
Code:
-- PlaylistName:SQL Jazz
-- PlaylistGroups:
select tracks.url from tracks
join
ok, tried your example in your first post above, and received the
following error:
Error:
near "join": syntax error
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed:
near "join": syntax error [for Statement "join track_statistics on
tracks.url=track_statistics.url and track_s
netchord wrote:
> Thanks Erland- i'll take a look- my preference is to do this with as few
> resources as possible, and without having to edit SQL by hand. would
> appreciate the template you mentioned, but for now it looks like i can
> uninstall Trackstat and DynamicPlaylist, since the latter i
Thanks Erland- i'll take a look- my preference is to do this with as few
resources as possible, and without having to edit SQL by hand. would
appreciate the template you mentioned, but for now it looks like i can
uninstall Trackstat and DynamicPlaylist, since the latter is not
necessary, and the
You will need SQL Playlist plugin also to accomplish something like
this.
At the moment I don't think there is a template for play counts, but I
can add that later this week and publish a new SQL Playlist version.
If you want to try it before then, you can create a customized version
with raw SQL
So, I'm trying to accomplish something in LMS that is extremely
straightforward in iTunes and most other PC media managers: build a
smart playlist based on a predefined set of criteria, in this case genre
& play count. these are not "more like this" or Genius style playlists,
where the playlist i
12 matches
Mail list logo
