> 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
Google added query/sort by id in a recent SDK release, and the new GAE driver that I am writing supports it, so this query will work soon. Robin On Feb 12, 11:03 pm, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
