For the following model
signature = db.Table(db, 'signature',
Field('created_on', 'datetime', default=request.now),
Field('created_by', db.auth_user, default=auth.user_id),
Field('updated_on', 'datetime', default=request.now),
Field('updated_by', db.auth_user, update=auth.user_id)
)
db.define_table('institution',
Field('name'),
Field('notes','text'),
Field('higher_education','boolean'),
Field('type_of_institution',
requires=IS_IN_SET(['University',
'University of Technology(Technikon)',
'College',
'NGO',
'Research Institute',
'Government',
'Private Sector']
)
),
Field('country'),
signature
)
db.define_table('journal',
Field('journal',unique=True),
Field('issn', length=10),
Field('notes', type='text'),
signature
)
appadmin complains:
Traceback (most recent call last):
File "/home/js/web2py/gluon/restricted.py", line 188, in restricted
exec ccode in environment
File "/home/js/web2py/applications/kb4/views/appadmin.html", line
88, in <module>
{{if hasattr(table,'_primarykey'):}}
File "/home/js/web2py/gluon/sql.py", line 2582, in __eq__
return Query(self, '=', value)
File "/home/js/web2py/gluon/sql.py", line 3034, in __init__
right = sql_represent(right, left.type, left._db._dbname,
left._db._db_codec)
File "/home/js/web2py/gluon/sql.py", line 569, in sql_represent
return str(int(obj))
ValueError: invalid literal for int() with base 10: 'string'
The tables are empty at the moment.
In the shell there is no problem.
Version
web2py Version 1.86.2 (2010-10-04 03:13:15)
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge
of God and of Jesus our Lord! His divine power has given us
everything we need for life and godliness through the full knowledge
of the one who called us by his own glory and excellence.
2 Pet. 1:2b,3a
