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).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
