I also got a key error and I ended up using workaround just like that one. I'll need to tune it a bit in the future so i don't end up with a monster teams dictionary. Or maybe when I update web2py i use massimo's solution. BTW, those joins are not supported by google app engine's datastore... or are they?
Anyway, thank you both for all the quick help. On 11 Dec, 18:02, DenesL <[EMAIL PROTECTED]> wrote: > Hard to use it if you don't know about it. > There was only one previous post mentioning it and it is not > documented anywhere else. > > I am not sure how CPU costly those double joins are but pedro could > have used: > > teams=dict(db().select(db.team.ALL).response) > matches=db().select(db.match.ALL) > for m in matches: print m.id,teams[m.t1],teams[m.t2] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---