Active SQL Playlist not working with game themes

[lumbergnz]

Can anyone help me with the active sql playlist feature I am trying to get my vpx tables into playlist themes I cant get any luck with this command” SELECT * FROM Games WHERE GameTheme=’Adventure’ ORDER BY GameDisplay; ” I have the games set as Adventure under game theme in games manager when i click test Activesql I get Error SQL logic error or missing database Im not sure if its possible or ive butchered the command but any insight would be great 

You need to login in order to like this post: click here

[NailBuster]

put adventure in ” instead of ‘

also so you don’t have to worry about case it maybe easier to put GameTheme like “%adventure%”

You need to login in order to like this post: click here

1 user thanked author for this post.

lumbergnz

[Author]

Posts