Thanks, I solved it with:
query = (db.rates.item_id==request.args(0)) &
~(db.rates.user_id==auth.user.id)
results = db(query).select(db.rates.user_id,
orderby=~db.rates.clicks)
maxrating = results[0].user_id
i can now use maxrating for my query.
On Monday, September 19, 2016 at 12:03:42 PM UTC+2, Kiran Subbaraman wrote:
>
> Check the structure of your returned result. Does it have 'clicks' as a
> first-level attribute? Or should it be 'rates.clicks'?
>
> ________________________________________
> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>
> On Mon, 19-09-2016 11:51 AM, Meinolf wrote:
>
> What could be wrong with my code below?
>
> sim = db((db.rates.item_id==request.args(0)) & ~(db.rates.user_id==
> auth.user.id)).select(db.rates.clicks.max()).first().clicks
>
> I need to access the value of the field *clicks* so that i can use it as
> a parameter in another query. It keeps giving me <type
> 'exceptions.AttributeError'>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> 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 web2py+un...@googlegroups.com <javascript:>.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
