uhm, I tested your on trunk, and also switched some things because I don't
have db.raw_material and db.run_as_rm, but
def add_composition():
form = SQLFORM.factory(
Field('dog_id', requires = IS_EMPTY_OR(IS_IN_SET(['a','b','c']))),
Field('cat_id', requires = IS_EMPTY_OR(IS_IN_SET(['a','b','c']))),
Field('number', 'double', requires = IS_NOT_EMPTY()),
Field('comment', 'text'),
Field('date', 'date'),
onvalidation = validate_survey)
if form.process(onvalidation = validate_survey).accepted:
response.flash = 'success'
redirect(URL('index'))
return dict(form=form)
works for me (i.e. error is shown if dog_id AND cat_id are selected, and if
there is no selection at all).
PS: works the IS_IN_DB version AND the IS_IN_SET version
On Friday, July 13, 2012 4:31:09 PM UTC+2, joe wrote:
>
> Just a note, this seems to fail in other situations as well
>
> My code:
>
> def add_composition():
> form = SQLFORM.factory(
> Field('dog_id', requires = IS_EMPTY_OR(IS_IN_DB(db,
> db.raw_material))),
> Field('cat_id', requires = IS_EMPTY_OR(IS_IN_DB(db,
> db.run_as_rm))),
> Field('number', 'double', requires = IS_NOT_EMPTY()),
> Field('comment', 'text'),
> Field('date', 'date'),
> onvalidation = validate_survey)
> if form.process(onvalidation = validate_survey).accepted:
> response.flash = 'success'
> redirect(URL('index'))
> return dict(form=form)
>
> def validate_survey(form):
> if form.vars.dog_id != None and form.vars.cat_id != None: #someone
> can't have a dog and a cat
> form.errors.dog_id = "Only one of these"
> form.errors.cat_id = "Only one of these"
> elif form.vars.dog_id==None and form.vars.cat_id==None: #but they need
> a pet (this is a simplified example)
> form.errors.dog_id = "You need a material"
> form.errors.cat_id = "you need a material"
>
> The validation somehow works if they are both empty, but not if they are
> both populated. (I have tested 'if form.vars.dog_id and form.vars.cat_id:'
> and that fails as well
>
