On Tuesday, April 24, 2018 at 1:30:42 PM UTC-7, Ayron Rangel wrote:
>
> Like this:
>
> {{for row in results:}}
> <tr>
> <td>{{=row.id}}</a></td>
> <td>{{=row.product}}</td>
>
>
> appears erros!!!!
>
>
>
For us to comment intelligently about the errors, you have to provide the
error details. Is there a ticket generated? No ticket, but the results
are wrong?
If that's all the code you have in the view, you may be missing the "pass"
statement. In views, "if" and and "for" require a "pass" to replace normal
end-by-unindent of regular python.
BTW, I prefer not to "return locals", as that may include information that
you didn't want to leak. An explicit
"return dict(results=results)" seems like a better idea to me.
/dps
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.
