True. The issue with JOIN is not an easy one to fix. Can you send me a patch about one or both issues?
Massimo On Oct 29, 11:43 am, "mr.freeze" <nat...@freezable.com> wrote: > Also, the as_list function only converts the first level of DALStorage > to dict when storage_to_dict is true. Both function (as_list,as_dict) > should probably recurse through all level right? > > On Oct 29, 11:27 am, "mr.freeze" <nat...@freezable.com> wrote: > > > Works for normal queries but throws a KeyError on id for joins. > > > On Oct 29, 10:12 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > ok, in trunk, take a look. > > > > On Oct 29, 9:26 am, Renato-ES-Brazil <caliari.ren...@gmail.com> wrote: > > > > > I agree. > > > > > On 29 out, 12:19, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > I think it is worth adding an as_dict function to Rows personally. > > > > > > On Oct 29, 9:01 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > My bad again > > > > > > > item_dict=dict([(r['id'],r) for r in db(db.items.id > 0).select > > > > > > ().as_list()]) > > > > > > > On Oct 29, 8:58 am, Fran <francisb...@googlemail.com> wrote: > > > > > > > > On Oct 29, 1:52 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > oops.there should be no sterisk. > > > > > > > > item_dict=dict([(r.id,r) for r in db(db.items.id > 0).select()]) > > > > > > > > Great, that works ;) > > > > > > > > This one still fails: > > > > > > > item_dict=dict([(r.id,r) for r in db(db.items.id > > > > > > > > 0).select().as_list > > > > > > > ()]) > > > > > > > > 'dict' object has no attribute 'id' > > > > > > > > Of course, this is already a dict: > > > > > > > db(db[table].id > 0).select().as_list() > > > > > > > > F > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
