...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, db.auth_user.id, > db.auth_user.first_name, db.guest.dia] > left = (db.voucher.on(db.guest.id == db.voucher.guest), > db.auth_user.on(db.guest.fnd == db.auth_user.id)) > form = SQLFORM.grid(query, fields=fields, left=left) > > On Thursday, October 15, 2015 at 2:59:51 PM UTC-5, Fabiano Almeida wrote: >> >> Hi! >> >> I try to show query on a SQLFORM.grid, but returns error: AttributeError: >> 'Rows' object has no attribute '_db' >> >> My code: >> >> query = db((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 , >> db.auth_user.first_name, db.guest.dia) >> form = SQLFORM.grid(query) >> >> How to show query on a grid? >> >> thx in advance, >> >> Fabiano. >> > -- 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/d/optout.
