Unless you have a material entry with an empty material.name in your
database, IS_IN_DB should prevent an empty submission.
On Mar 6, 11:44 am, raven <ravenspo...@yahoo.com> wrote:
> I have a field that references another table
>
> Field('material', db.material)
>
> I can get SQLFORM to give me a drop down list of available material
> names
>
> Field('material', db.material,
> requires=IS_IN_DB(db,'material.id','material.name'))
>
> I can get SQLFORM to insist on filling the field
>
> Field('material', db.material,
> requires=IS_NOT_EMPTY())
>
> I would like to get both at once. However
>
> Field('material', db.material,
> requires=[IS_IN_DB(db,'material.id','material.name'),IS_NOT_EMPTY()])
>
> does not show the drop down list.
>
> The problem seems to be in placing IS_IN_DB inside a list,
> because this does not work
>
> Field('material', db.material,
> requires=[IS_IN_DB(db,'material.id','material.name')])
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@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.
