[web2py] Re: Display reference fields in read-only form

2010-05-20 Thread selecta
yes with Andrew Buchan tip of leaving out the requires it worked for me too, however the solution was rather unintuitive tnx to everybody for taking time to check this problem On May 19, 1:00 pm, mdipierro wrote: > For me this works > > db.define_table('person', >         Field('name'), >        

[web2py] Re: Display reference fields in read-only form

2010-05-19 Thread mdipierro
For me this works db.define_table('person', Field('name'), format = "%(name)s", ) db.define_table('contributers', Field('person', db.person), # <<< requires not necessary ) def edit_contributer(): db.contributers.person.writable = False record = request

[web2py] Re: Display reference fields in read-only form

2010-05-18 Thread Andrew Buchan
Hi, I'm the original poster, but just changed my email... I did get this to work so will post the solution for others: Here's the table: db.define_table('department', Field('Department_Name', requires = IS_NOT_EMPTY()), Field('contact_email', length=128, requires = [IS_EMAIL(), IS_NOT_EMPT

[web2py] Re: Display reference fields in read-only form

2010-05-18 Thread selecta
I have a similar problem db.define_table('person', Field('name'), format = "%(name)s", ) db.define_table('contributers', Field('person', db.person, requires = IS_IN_DB(db, 'person.id', '%(name)s')), ) def edit_contributer(): db.contributers.person.writabl

[web2py] Re: Display reference fields in read-only form

2010-05-17 Thread howesc
Hi, i have this defined as a model: db.define_table('question', Field('question', 'string', length=1056, notnull=True, unique=True, requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db,'question.question')]), #version info Field('created_by', db.auth_user, default=auth.user_id

[web2py] Re: Display reference fields in read-only form

2010-05-17 Thread mdipierro
yes. I misread the previous emails so my answer was wrong. On May 17, 11:22 am, Iceberg wrote: > Not sure. Can't Field(..., writable=False) do the trick? > > On May17, 5:44pm, Andrew Buchan wrote: > > > Hi all, > > If I have a referenced field where I specify which field in the referenced > > t

[web2py] Re: Display reference fields in read-only form

2010-05-17 Thread Iceberg
Not sure. Can't Field(..., writable=False) do the trick? On May17, 5:44pm, Andrew Buchan wrote: > Hi all, > If I have a referenced field where I specify which field in the referenced > table to display, like so: > Field('To_Department', requires = IS_IN_DB(db, db.department.id, > '%(Department_

[web2py] Re: Display reference fields in read-only form

2010-05-17 Thread mdipierro
db.table.To_Department.represent=lambda v: db.department[v].Department_Name or better remove requires = IS_IN_DB(db, db.department.id, '% (Department_Name)s' and set db.define_table('department',,format='%(Department_Name)s') On May 17, 4:44 am, Andrew Buchan wrote: > Hi all, > If I have