Expression in 3-rd parameter of IS_IN_DB()

6 views
Skip to first unread message

Mirek Zvolský

unread,
Nov 25, 2010, 10:11:04 AM11/25/10
to web2py-users
I'm sorry that I repeat my question, but I still cannot find solution.

Following works:
IS_IN_DB(db, 'lesson.id', '%(name)s')

And now I need an expression in 3-rd parameter instead of simple field
name, something like:
IS_IN_DB(db, 'lesson.id', '%(name.upper())s')
to see all names in Uppercase. This however doesn't work.

Is there a way how to do it?
Thanks in advance.
Mirek

mdipierro

unread,
Nov 25, 2010, 10:57:25 AM11/25/10
to web2py-users
IS_IN_DB(db, 'lesson.id', lambda r: r['name'].upper())

this may work.

Mirek Zvolský

unread,
Nov 26, 2010, 8:43:14 AM11/26/10
to web2py-users
>> IS_IN_DB(db, 'lesson.id', lambda r: r['name'].upper())

Thank you very much, works excellent !
Reply all
Reply to author
Forward
0 new messages