Hi Massimo,
Yes, it works ! But when I try to use IS_NOT_IN_DB with IS_IN_DB, I
can't obtain a drop down list, even if I change the order of the
lines. Here's my code :
db.define_table('zonedef',
SQLField('nom'))
db.zonedef.nom.requires=[IS_NOT_EMPTY(error_message='can't be
empty!'),IS_NOT_IN_DB(db,'zonedef.nom')]
db.zonedef.represent=lambda zonedef:
A(zonedef.nom,_href=t2.action('update',zonedef.id))
db.define_table('u_name',
SQLField('nom'),
SQLField('description',length=128))
db.define_table('u',
SQLField('unit_id',db.u_name),
SQLField('zd_id',db.zonedef),
SQLField('nb_u','double'))
db.u.zd_id.requires=IS_IN_DB(db,'zonedef.id','%(nom)s')
db.u.unit_id.requires=IS_IN_DB(db,'u_name.id','%(nom)s : (description)
s')
db.u.zd_id.requires=IS_NOT_IN_DB(db
(db.u.unit_id==request.vars.unit_id),'u.zd_id')
Can you help me to fix it, Massimo ?
On 12 déc 2008, 23:24, mdipierro <mdipie...@cs.depaul.edu> 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.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
