In db.py I have:
db.define_table('Node',
Field('createdOn',type='datetime',writable=False,readable=False),
Field('modifiedOn',type='datetime',writable=
False,readable=False),
migrate=False)
db.define_table('Organization',
Field('nodeID',db.Node,default='',notnull=True,ondelete='RESTRICT',writable=False,readable=False),
Field('name',length=128,default='',notnull=True),
...
migrate=False)
db.define_table('NodeRelatedCard',
Field('sourceID',db.Node,default='',notnull=True,ondelete='CASCADE',writable=False,readable=False),
Field('targetID',db.Node,default='',notnull=True,ondelete='CASCADE'),
...
migrate=False)
In a function I have:
row=db(db.NodeRelatedCard.id==request.args(1)).select().first()
In the update form of this function I would like targetID to be
represented by Organization.name. I tried:
db.NodeRelatedCard.targetID.represent= lambda targetID, row:
db.Organization(targetID).name
but that doesn't work. What is the correct syntax to get this to work.
Kind regards,
Annet.
