hi all,
i don't know how to decode the field in one to many relation
when i show "rows" i want to decode Customer_storage.Object_id whit
Storage.Model for shwo to user a table like this:
Object Serial number Serial number sostituito Garanzia
Note
ACME123 23s332
45d54 2012/07/02 nothing
thanks for help
my db:
db.define_table('Storage',
Field('Developer'),
Field('Model'),
Field('Version'),
Field('Colour'),
Field('Note', 'text'),
Field
('Data_creation','datetime',default=request.now,writable=False,readable=False))
db.define_table('Customer_storage',
Field('Object_id',db.Storage, label='Dispositivo'),
Field('Customer_id',db.Customers,writable=False,readable=True),
Field('Sn', label='Serial number'),
Field('Sn_sostituito', label='Serial number se sostituito'),
Field('Garanzia', 'date', label='Data fine garanzia'),
Field('Note', 'text'),
Field
('Data_creation','datetime',default=request.now,writable=False,readable=False))
my code:
def materiale():
id_customer=request.args(0)
rows=db(db.Customer_storage.Customer_id==id_customer).select
(orderby=db.Customer_storage.Object_id)
db.Customer_storage.Customer_id.default=id_customer
form=crud.create(db.Customer_storage, next=url
('materiale',id_customer))
return dict(form=form,rows=rows)
--
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.
