Just upgraded to latest trunk, Version
2.6.0-development+timestamp.2013.07.20.12.59.52.
Having a problem with SUM statements that previously worked.
If the query returns no rows, then I'm getting this traceback:
Traceback (most recent call last):
File "C:\dev\web2py\gluon\restricted.py", line 212, in restricted
exec ccode in environment
File "C:/dev/web2py/applications/ibc/controllers/dashboard.py"
<http://127.0.0.1:8000/admin/default/edit/ibc/controllers/dashboard.py>, line
2035, in <module>
File "C:\dev\web2py\gluon\globals.py", line 193, in <lambda>
self._caller = lambda f: f()
File "C:/dev/web2py/applications/ibc/controllers/dashboard.py"
<http://127.0.0.1:8000/admin/default/edit/ibc/controllers/dashboard.py>, line
1094, in contract_fees_ytd_by_distributor
(db.national_sales_data.Invoice_Print_Date__c<=to_date)).select(processing_fees_sum).first()[processing_fees_sum]
or 0
File "C:\dev\web2py\gluon\dal.py", line 6888, in __getitem__
return ogetattr(self, key)
AttributeError: 'Row' object has no attribute
'SUM(national_sales_data.Processing_Fees__c)'
My code is:
processing_fees =
db((db.national_sales_data.Invoice_Print_Date__c>=from_date) &
(db.national_sales_data.Trading_Partner_ID__c==trading_partner) &
(db.national_sales_data.Invoice_Print_Date__c<=to_date)).select(processing_fees_sum).first()[processing_fees_sum]
or 0
Previously this would return 0 if there were no rows selected in the query.
-Jim
--
---
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/groups/opt_out.
