[web2py] Re: How to show query on a grid?

2015-10-19 Thread Fabiano Almeida
Delete the db before ((db.guest.id>0)... worked query = ((db.guest.id>0) & \ > (db.voucher.disp == False) & \ > (db.voucher.guest == db.guest.id) & \ > (db.auth_user.id == db.guest.fnd)) \ > .select(db.voucher.voucher, db.guest.name, db.auth_user.id , >

[web2py] Re: How to show query on a grid?

2015-10-15 Thread Jim S
...not tested, but you should get the general idea. Hit me back up if this is confusing to you. -Jim On Thursday, October 15, 2015 at 3:27:14 PM UTC-5, Jim S wrote: > > Try this: > > > query = (db.guest.id>0) & (db.voucher.disp == False) > fields = [db.voucher.voucher, db.guest.name,

[web2py] Re: How to show query on a grid?

2015-10-15 Thread Jim S
Try this: query = (db.guest.id>0) & \ (db.voucher.disp == False) & \ (db.voucher.guest == db.guest.id) & \ (db.auth_user.id == db.guest.fnd) fields = [db.voucher.voucher, db.guest.name, db.auth_user.id, db.auth_user.first_name, db.guest.dia] form =