Like this: {{for row in results:}} <tr> <td>{{=row.id}}</a></td> <td>{{=row.product}}</td>
appears erros!!!! Em terça-feira, 24 de abril de 2018 16:59:11 UTC-3, Dave S escreveu: > > > > On Tuesday, April 24, 2018 at 6:49:57 AM UTC-7, Ayron Rangel wrote: >> >> Guys, >> >> How can i print this in HTML (CUSTOM) DAL : >> def stock (): >> sum = db.input_inventory.input_price.sum() >> count = db.input_inventory.product.count() >> results = db(db.input_inventory).select(db.input_inventory.product, >> count, sum, groupby = db.product) >> return locals() >> >> HMTL: >> {{row in results:}} >> <td>{{}}</td> >> >> > > You can fill in the table yourself using a for-loop: > <URL:http://web2py.com/books/default/chapter/29/05/the-views#for---in> > or you could use SQLTABLE. I have examples of both in my projects. > > I think SQLFORM.grid can also be used, but you may have to set writable > FALSE for everything if you don't want it edited. > > Then there's Datatables and similiar libraries if you want spreadsheet > behavior. > <URL:https://datatables.net> > <URL:https://groups.google.com/forum/#!topic/web2py/RRNmkDr5CDE> > > /dps > > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.