yes.
where = [(db.auth_user.first_name == 'Jambon'), (db.auth_user.last_name ==
'Forêt Noir')] # etc etc
query = reduce(lambda a,b:a&b, where)
rows = db(query).select()
On Thursday, 31 October 2013 11:14:22 UTC-5, Richard wrote:
>
> Hello,
>
> I found this solution :
>
> where_1 = (db.auth_user.first_name == 'Jambon')
> where_2 = (db.auth_user.last_name == 'Forêt Noir')
> where_3 = ''
> where_4 = ''
> where_5 = ''
> where_6 = ''
>
> where_clauses = {'where_1': where_1,
> 'where_2': where_2, 'where_3': where_3,
> 'where_4': where_4, 'where_5': where_5,
> 'where_6': where_6}
>
> where_clauses_list = []
> for k, value in where_clauses.iteritems():
> if value:
> where_clauses_list.append(k)
> if len(where_clauses_list) == 2:
> test123 = db(where_clauses[where_clauses_list[0]] &
> where_clauses[where_clauses_list[1]])
>
>
> myselect = test123.select(db.auth_user.ALL)
>
> But I would like to know it there is a better/simpler way to create a db()
> set for a finite number of where clauses ((db.auth_user.field ...) == one
> where clause) ?
>
> Thanks
>
> Richard
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
