[web2py] Re: put multiple database tables like grid in one place

2017-08-29 Thread 黄祥
got it, my bad forget to add .as_list() on the rows thanks and best regards, stifan -- 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 mes

[web2py] Re: put multiple database tables like grid in one place

2017-08-29 Thread Val K
as_list() is missed, try: people = json.dumps(rows.as_list()) On Tuesday, August 29, 2017 at 4:45:47 AM UTC+3, 黄祥 wrote: > > trying your suggestion with datatables that have web2py multiple table > relations join > *ref:* > > http://www.web2pyslices.com/slice/show/2052/using-datatablesnet-with-

[web2py] Re: put multiple database tables like grid in one place

2017-08-28 Thread 黄祥
trying your suggestion with datatables that have web2py multiple table relations join *ref:* http://www.web2pyslices.com/slice/show/2052/using-datatablesnet-with-web2py-for-ultra-fast-grid-display *models/db.py* db.define_table('sale_order', Field('sale_order_no') ) db.define_table('cash_in', Fie

[web2py] Re: put multiple database tables like grid in one place

2017-08-28 Thread Dave S
On Monday, August 28, 2017 at 2:50:29 PM UTC-7, 黄祥 wrote: > > my current models > db.define_table('sale_order', > Field('sale_order_no'), > Field('sale_order_date', 'date'), > Field('customer', 'reference customer'), > Field('product', 'reference product'), > Field('quantity', 'integer'), > F

[web2py] Re: put multiple database tables like grid in one place

2017-08-28 Thread 黄祥
my current models db.define_table('sale_order', Field('sale_order_no'), Field('sale_order_date', 'date'), Field('customer', 'reference customer'), Field('product', 'reference product'), Field('quantity', 'integer'), Field('price', 'double'), Field('total_price', 'double'), Field('grand_total',

[web2py] Re: put multiple database tables like grid in one place

2017-08-28 Thread Dave S
On Wednesday, August 23, 2017 at 2:58:49 PM UTC-7, 黄祥 wrote: > > is there any way to put multiple database tables like grid in one place > using web2py way? > Can you sketch some sort of mock up, so we have a clearer idea of what you'd like? > tried before just using 2 database tables, and