sorry:

db.define_table('y',
    db.Field('name','string')
    )
db.define_table('x',
    db.Field('y_id',db.y,requires=IS_IN_DB(db,'y.id','%(name)s')),
    db.Field('name','string'),
)
db.x.name.requires=[
        IS_NOT_EMPTY(),
        IS_NOT_IN_DB(db(db.x.y_id==request.vars.y_id),'x.name')
        ]

On Jun 27, 11:39 pm, weheh <richard_gor...@verizon.net> wrote:
> Massimo, unfortunately, the suggestion didn't work. I got a traceback
> that ends with:
>
> Traceback (most recent call last):
>   File "gluon/restricted.py", line 107, in restricted
>   File "C:/web2py/applications/test/models/test.py", line 8, in
> <module>
>   File "gluon/sql.py", line 525, in __getattr__
> KeyError: 'x'
>
> The entire test case is:
>
> db.define_table('y',
>     db.Field('name','string')
>     )
> db.define_table('x',
>     db.Field('y_id',db.y,requires=IS_IN_DB(db,'y.id','%(name)s')),
>     db.Field('name','string',requires=[
>         IS_NOT_EMPTY(),
>         IS_NOT_IN_DB(db(db.x.y_id==request.vars.y_id),'x.name')
>         ]
>     ),
> )
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to