Works for normal queries but throws a KeyError on id for joins.

On Oct 29, 10:12 am, mdipierro <[email protected]> wrote:
> ok, in trunk, take a look.
>
> On Oct 29, 9:26 am, Renato-ES-Brazil <[email protected]> wrote:
>
> > I agree.
>
> > On 29 out, 12:19, "mr.freeze" <[email protected]> wrote:
>
> > > I think it is worth adding an as_dict function to Rows personally.
>
> > > On Oct 29, 9:01 am, mdipierro <[email protected]> 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 <[email protected]> wrote:
>
> > > > > On Oct 29, 1:52 pm, mdipierro <[email protected]> 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 [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to