Portion of expression could not be parsed: AND
I know this is basic, but I just can't get a select statement with an AND in the where clause to work in GQL. I've boiled the problem down开发者_StackOverflow社区 to this
SELECT * FROM entity WHERE acctName == 'Company 1' AND acctID == 87896657
I get
Portion of expression could not be parsed: AND acctID == 87896657
If I change the order of the AND the message appears for the second item acctName. If I run the select with each of them alone it works fine. This all indicates that the problem is with the AND. GQL must support AND, right?
Thanks for any help!
Try this:
db.GqlQuery("SELECT * FROM entity WHERE acctName = :1 AND acctID = :2", "Company 1", 87896657)
The questioner must be asking for the problem in Java. If it is the case, you should take a look at this post GQL error on WHERE
精彩评论