In a validator I combine IS_IN_DB() and IS_NOT_IN_DB. I tried solving
the 'no automatic drop box' issue by adding a widget based on an
unnamed function:
db.define_table('adressoort',
db.Field('soort',length=30,default='',notnull=True,unique=True),
migrate='adressoort.table')
db.adressoort.soort.requires=[IS_LENGTH(30,error_message='lengte
overschreidt 30 tekens'),IS_NOT_EMPTY(),IS_NOT_IN_DB
(db,'adressoort.soort',error_message='soort niet uniek')]
db.adressoort.soort.label='Soort * '
db.define_table('adres',
db.Field
('bedrijf',db.bedrijf,default='',notnull=True,ondelete='CASCADE'),
db.Field
('adressoort',db.adressoort,default='',notnull=True,ondelete='RESTRICT'),
db.Field(...),
migrate='adres.table')
...
db.adres.adressoort.requires=[IS_IN_DB(db,db.adressoort.id,'%(soort)
s',orderby=db.adressoort.id),IS_NOT_IN_DB(db
(db.adres.bedrijf==request.vars.bedrijf),db.adres.adressoort)]
db.adres.adressoort.widget=lambda f,v: OptionsWidget.widget(SQLField
('adressoort',db.adressoort,requires=db.adres.adressoort.requires
[0]),v)
...
this results in an error:
File "/Library/Python/2.5/site-packages/web2py_1_65_0/gluon/
sqlhtml.py", line 50, in _attributes
_id = '%s_%s' % (field._tablename, field.name),
AttributeError: 'SQLField' object has no attribute '_tablename'
I wonder whether this problem has been solved with the introduction of
version 1.65. I read the slides, but the examples are all based on an
IS_IN_SET() validator, not on a table field.
Kind regards,
Annet.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
