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}}
throws this error
<type 'exceptions.AttributeError'>('Rows' object has no attribute 'weekly')
if {{=prices}} is used I'm getting beautify output will all fields and
records displayed
Starting to think that this is maybe a bug. From what I know about web2py
{{=prices.weekly}} should work, and it works outside for loop. So, problem
happens only when called from within {{for}} loop!? I'm still on Version
1.99.1 (2011-09-22 16:59:24) stable.
To say a word on your prevision post: As I'm still learning web2py, I left
"joins" for later stage, but I guess there is no time like now :) .I'm aware
join is way forward and once I get working sample, I'll post the code here.
Thanks for code.
p.s.
This just came to me: community that never sleep, web2py. As I’m in GMT zone
(I know know - it's Saturday nite - no life) I wasn't expecting so prompt
answer. ..even if you are in EST, it's still late :) This is what I call
dedication!! web2py community rocks
