I am playing with an SQL playlist and I just wondered if it was possible
to declare a variable for use in multiple places?

I currently have this


Code:
--------------------
    where
  audio=1
  and dynamicplaylist_history.id is null
  and (track_statistics.rating>=70)
  and genres.name in ('Metal')
--------------------


...but would like do something like


Code:
--------------------
    GENRE='Metal'
  
  and genres.name in (GENRE)
--------------------


Is this possible? If so what is the correct syntax?


------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=49483

_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins

Reply via email to