Gibran,
Just use db.Person, not db.Person.id:
Field('person_id',db.Person)
You can then specify the dropdown:
db.Activity.person_id.requires = IS_IN_DB(db,
'Person.id',
'%(id)s %(name)s',)
Or formatted however you want it to appear.
BTW: The convention would probably be to use 'person'
as your field name in Activity, rather than 'person_id'.
Jeff Bauer
Rubicon, Inc.
On 01/17/2010 08:20 PM, Gibran Rodriguez wrote:
I have 2 tables
db.define_table('Person',
Field('name',length=45),
Field('info','text'),
migrate=False)
db.define_table('Activity',
Field('type',length=45),
Field('start_date','date'),
Field('end_date','date'),
Field('money',length=45),
Field('price','double'),
Field('person_id',db.Person.id <http://db.Person.id>))
Field('extra_info',length=45),
Field('owner_user_id',length=4),
Field('hour','double'),
migrate=False)
so I want to use the Person.id for the field person_id in the table
Activity so that I get a drop downlist of the existing ids but I get the
following error?
File "/home/brangi/Desktop/web2py/gluon/sql.py", line 1242, in define_table
t = self[tablename] = Table(self, tablename, *fields)
File "/home/brangi/Desktop/web2py/gluon/sql.py", line 1476, in __init__
if field.type == 'id':
File "/home/brangi/Desktop/web2py/gluon/sql.py", line 2383, in __eq__
return Query(self, '=', value)
File "/home/brangi/Desktop/web2py/gluon/sql.py", line 2788, in __init__
right = sql_represent(right, left.type, left._db._dbname,
left._db._db_codec)
File "/home/brangi/Desktop/web2py/gluon/sql.py", line 502, in
sql_represent
return str(int(obj))
ValueError: invalid literal for int() with base 10: 'id'
--
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.
--
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.
