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 -~----------~----~----~----~------~----~------~--~---