gql query returns BadQueryError: Parse Error

Question

This is my gql code:

data = db.GqlQuery("SELECT * FROM Playlist " + "WHERE tags = :1" + "ORDER BY :2", tag, order)

and I get this error:

BadQueryError: Parse Error: Expected no additional symbols at symbol BY

Does anyone know what I am doing wrong?

thanks for the help J

Answer 1

You seem to be concatenating the GQL string for some unknown reason and have missed a space. Try:

data = db.GqlQuery("SELECT * FROM Playlist WHERE tags = :1 ORDER BY :2", tag, order)

Answer 2

You're missing a space before ORDER.