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.

Reply via email to