No. validators are associated to one field in the sense that only one
field will report the error.
db.define_table('t',SQLField('f1'),SQLField('f'2'))
db.t.f2.requires=IS_NOT_IN_DB(db(db.t.f1==request.vars.f1),'t.f2')
OR
db.t.f1.requires=IS_NOT_IN_DB(db(db.t.f2==request.vars.f2),'t.f1')
are equivalent and do exactly what you ask. except that the former
associates the error with the f1 value and the second to the f2 value.
They both generate the query
db((db.t.f1==request.vars.f1)&(db.t.f2==request.vars.f2)).count()
Massimo
On Dec 12, 4:01 pm, DenesL <denes1...@yahoo.ca> wrote:
> On Dec 12, 4:07 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I still do not see why you cannot use IS_NOT_IN_DB(sqlset,....) You
> > must have access to the variables that you want to validate.
>
> Correct me if I am wrong but IS_NOT_IN_DB only looks at the value of
> one field.
> From validators.py:
> rows=self.dbset(field=value).select(limitby=(0,1))
>
> What we are thinking is:
> [field1value,field2value,field3value,...] as a row is not in the DB.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
