[web2py] Re: GAE shows error

never mind, I got it working, by modifying candidate =db(db.words.word.lower()==trans_form.vars.word.lower())(db.words.lang==trans_form.vars.languages).select().first() to candidate = db(db.words.lang==trans_form.vars.languages).select().find(lambda x:x.word.lower()==trans_form.vars.word.low

[web2py] Re: GAE shows error

GAE does not allow this query: db.words.word.lower()==trans_form.vars.word.lower() In SQL this would be ... WHERE LOWER(words.word) = ' value of trans_form.vars.word.lower() ' but GAE has no LOWER. On Dec 31, 4:54 am, "Arun K.Rajeevan" wrote: > Once again my application runs fine on suppl

[web2py] Re: GAE shows error

I'm using Version 1.91.5 (2010-12-28 21:52:10)