You cannot mix ID and other fields in a GAE query. For gae ID is not a field and it is treated differently.
r=db(db.cas_user.id==id).select() #OK r=db(db.cas_user.verification==key).select() #OK r=db(db.cas_user.id==id)(db.cas_user.verification==key).select() #OK but not on GAE do this instead r=[x for x in db(db.cas_user.id==id).select() if x.verification==key] Massimo On Feb 12, 6:38 pm, "Sebastian E. Ovide" <[email protected]> wrote: > Hi All, > > I'm getting an error on the line 124 the folowing query (only in GAE) > > 123 r=db(db.cas_user.id==id)\ > 124 (db.cas_user.verification==key)\ > 125 .select() > > the error is > > File "C:\dev\centralauthservice\gluon\restricted.py", line 98, in > restricted > exec ccode in environment > File "C:\dev\centralauthservice\applications\cas/controllers/cas.py", line > 188, in <module> > File "C:\dev\centralauthservice\gluon\globals.py", line 74, in <lambda> > self._caller = lambda f: f() > File "C:\dev\centralauthservice\applications\cas/controllers/cas.py", line > 124, in verify > (db.cas_user.verification==key)\ > File "C:\dev\centralauthservice\gluon\contrib\gql.py", line 634, in > __call__ > raise SyntaxError > SyntaxError: None > > any ideas ? > > ---------------------------- > Sebastian E. Ovide --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
