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