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.