I tried both approaches but i get the following error:
<type 'exceptions.AttributeError'> 'Rows' object has no attribute 'values'

the Rows object being referred to in the error is *getcourseids, *which is 
true because it holds a set of rows retrieved from the database before. How 
can i get around it then?

On Tuesday, September 20, 2016 at 11:18:10 PM UTC+2, villas wrote:
> Maybe you could better use more of the power of web2py.  Something like 
> this....?
> s = db( db.item.id.belongs(getcourseids.values()) ).select(
>            db.item.course_title).as_list()
> or perhaps a bit longer,  something like this...
> rows = db( db.item.id.belongs(getcourseids.values()) ).select(
>            db.item.course_title)
> s = [r.course_title for r in rows]
> On Monday, 19 September 2016 18:59:27 UTC+1, Meinolf wrote:
>> Hi There,
>> When i test the code below, for a list that is supposed to have multiple 
>> items, i only get one result for the last item, did i miss something in the 
>> for loop or anywhere else?
>> for i in range(0, (len(getcourseids)-1)):
>>             c = db.item.id==getcourseids[i].item_id
>>             s.append(db(c).select(db.item.course_title)[i])
>> Any help will be appreciated.

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

Reply via email to