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.
