Consider this:
model:
db.define_table('x',db.Field('y_id',db.y,requires=IS_NULL_OR(IS_IN_DB
(db,'y.id','%(name)s'))))
db.define_table('y',db.Field('name','string',requires=[IS_NOT_EMPTY
(),IS_NOT_IN_DB(db,'y.name')]))
controller:
try:
records = db(db.x.id==int(request.args[1]))
valid_y_ids = [1,2,3] # under normal circumstances, this is
computed on the fly based on other db entries
db.x.y_id.requires=IS_IN_SET(valid_y_ids)
form=SQLFORM(db.x,record=records,submit_button='update')
except:
form=SQLFORM(db.x,submit_button='new')
What I want is that the requires clause in the try section should
cause the form to display the names of entries in the y table that
match the valid_y_ids list. What I get is just the id numbers in the
valid_y_ids. How do I get the names, instead?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
