what db? The left=... only works on rdbms, not on GAE.
On Feb 1, 1:50 am, ceriox <[email protected]> wrote: > thanks for help but for the first solution i have a syntax error > > Traceback (most recent call last): > File "gluon/restricted.py", line 171, in restricted > File "G:/web2py/applications/Siltel/controllers/default.py", line 41 > (db.Customer_storage.ALL,db.Storage.Model,left=db.Storage.on > ^ > SyntaxError: invalid syntax > > for the second solution i can't understand what you mean (i'm not an > expert programmer in web2py) > > do you mean in the view show the field with: > {{=db.Storage[row.Object_id].Model}} ?? > > > I see two ways: > > > 1) Using a left join > > > rows==db(db.Customer_storage.Customer_id==id_customer).select > > (db.Customer_storage.ALL,db.Storage.Model,left=db.Storage.on > > (db.Customer_storage.Object_id==db.Storage.id),orderby=db.Customer_storage.Object_id) > > > so now rows includes a Storage.Model column > > > 2) In the view display db.Storage[row.Object_id].Model for each row in > > rows > > > Denes. > > -- 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.
