I have 5 records in my database. The following code gives me duplicate 
records. Currently every record is duplicated 5 times.

Anu idwhat is going wrong.
   
 RSRisks = db(
                 (db.risks.user == userid)&
                 (db.risks.status == status)
                 ).select(
                join = [db.teams.with_alias('team').on(db.teams.id == db.
risks.team).
                        db.users.with_alias('user').on(db.users.id == db.
risks.user).
                        db.users.with_alias('risk_owner').on(db.users.id ==db
.risks.risk_owner).
                        db.platforms.with_alias('id_platform').on(db.
platforms.id == db.risks.id_platform).
                        db.contracts.with_alias('id_contract').on(db.
contracts.id == db.risks.id_contract).
                        db.suppliers.with_alias('id_supplier').on(db.
suppliers.id == db.risks.id_supplier)
                        ]
                                  )

Thanks
So,pm

-- 

--- 
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to