On Sunday, March 9, 2014 3:52:23 AM UTC-7, Niphlod wrote:
>
> that's because you're using the most unrecommended way to refer to an
> aggregate (relying on a fixed representation...).
> Did you try
>
> count = db.pagos.count()
>
Does drayco want to display the count of all the pages in the database, or
the count of all the pages in the selection? I thought the latter from
reading his message, but your suggestion counts th former, does it not?
> totalPagos =
> SQLTABLE(db((db.pagos.created_on>inicio)&(db.pagos.created_on<fin)).\
> select(count), headers={count:'Total Pagos'})
>
> ?
>
>
/dps
> On Friday, March 7, 2014 9:00:40 PM UTC+1, drayco wrote:
>>
>> All code work with web2py 2.8.3 but when we upgrade to web2py 2.9.4, we
>> use extensive SQLTABLE and in this moment we have a lot of errors similar to
>>
>> File "/home/drayco/webapps/newconfig/web2py/gluon/sqlhtml.py", line 2929, in
>> __init__
>> columns =
>> ['.'.join(sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.match(c).groups()) for c
>> in sqlrows.colnames]
>> AttributeError: 'NoneType' object has no attribute 'groups'
>>
>>
>> This is our code
>>
>> totalPagos =
>> SQLTABLE(db((db.pagos.created_on>inicio)&(db.pagos.created_on<fin)).\
>> select(db.pagos.id.count()),
>> headers={'COUNT(pagos.id)':'Total Pagos'})
>>
>> What can we do?
>>
>> Can you help me please?
>>
>
--
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.
