[web2py:13570] Re: Validate multiple fields

[Timothy Farrell]

Massimo, We have a difference of design philosophy here.  Maybe we'll revisit this later. -tim mdipierro wrote: 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. -- Timothy Farrell <tfarr...@swgen.com> Computer Guy Statewide General Insurance Agency (www.swgen.com) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---