Thanks. Really appreciate the prompt reply on a Sunday morning!!
Jim
On Jul 21, 2013 9:22 AM, "Michele Comitini" <[email protected]>
wrote:
> There is a bug. must be None i.e. the result is not defined.
>
> I fixed the bug and I will send the PR asap
>
> db.define_table('tt', Field('aa', 'integer'))
>
> assert(db(db.tt.aa == 2).count()==0)
> sum = (db.tt.aa + 1).sum()
> assert(db(db.tt.aa == 2).select(sum).first()[sum]==0)
> -> AssertionError
>
> I added tests for travis too.
>
>
> 2013/7/21 Jim Steil <[email protected]>
>
>> Do you have a test you can run on it? None of mine are working and I
>> just updated in the last hour.
>>
>>
>> On Sun, Jul 21, 2013 at 8:48 AM, Niphlod <[email protected]> wrote:
>>
>>> this should have been fixed already on the latest trunk....
>>>
>>>
>>> On Sunday, July 21, 2013 3:33:51 PM UTC+2, Jim S wrote:
>>>>
>>>> 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.Invoic**e_Print_Date__c<=to_date)).sel**ect(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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/hgYEY3ZdSK4/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>>
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>> --
>>
>> ---
>> 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.
>>
>>
>>
>
> --
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/hgYEY3ZdSK4/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
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.
