try: print db((db.matches.team1_id==db.teams.id)& (db.matches.team2_id==db.teams.id))._select()
_select not select and you will see this is the same as the SQL query below. I guess no records match the query. Massimo On Dec 10, 3:36 pm, pedro <[EMAIL PROTECTED]> wrote: > Ok, this is what i am trying to replicate using web2py data object > model: > > SELECT * FROM teams, matches WHERE matches.team1_id=teams.id AND > matches.team2_id=teams.id > > This is what I've used, but it returns an empty record. > > partidas = db( db.matches.team1_id==db.teams.id) & > (db.matches.team2_id==db.teams.id)).select() > > What am I doing wrong? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
