I tried it but i got another error
CONTROLLER
def dashboard_admin():
query = (db.payslip.state == 'Confirmed')
sum = db.payslip.gross.sum()
print db(query).select(sum).first()[sum]
return locals()
Error
Traceback (most recent call last):
File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\restricted.py", line 227,
in restricted
exec ccode in environment
File
"D:/lab/PycharmProjects/Smartwork/web2py/applications/smartwork/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/smartwork/controllers/default.py>,
line 1212, in <module>
File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\globals.py", line 417, in
<lambda>
self._caller = lambda f: f()
File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\tools.py", line 4241, in f
return action(*a, **b)
File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\tools.py", line 4241, in f
return action(*a, **b)
File
"D:/lab/PycharmProjects/Smartwork/web2py/applications/smartwork/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/smartwork/controllers/default.py>,
line 42, in dashboard_admin
print db(query).select(sum).first()[sum]
IOError: [Errno 22] Invalid argument
On Friday, September 30, 2016 at 4:43:05 AM UTC+3, 黄祥 wrote:
>
> pls try :
> query = (db.payslip.state == 'Confirmed')
> sum = db.payslip.gross.sum()
> print db(query).select(sum).first()[sum]
>
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum--avg--min--max-and-len
>
> 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 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.
