Thanks Anthony. That worked. I shouldn’t be working so late on my project I
make silly copy and paste mistakes.
On 9 October 2011 12:25, Anthony <abasta...@gmail.com> wrote:
> On Sunday, October 9, 2011 12:51:32 AM UTC-4, IK wrote:
>>
>> Out of 6 listing_item records, 2 didn't had price records. I deleted
>> those two listing_item records but I'm still getting the same problem.
>>
>> To recap
>> {{for item ...
>> {{prices=db(db.price.listing==**item.id <http://item.id>
>> ).select(orderby=db.**price.weekly,distinct=True)}}
>> {{=prices.weekly.last()}}
>> OR
>> {{=prices.weekly}}
>>
>
> Is that your exact code? Note, prices is a Rows object -- before accessing
> a field, you first have to extract an individual Row. So it would be
> prices.last().weekly, not prices.weekly.last().
>
> Anthony
>
>
