hi,

i'm just starting to learn web2py and i'm worndering what i'm doing wrong
here:

my db.py contains:

import datetime
now=datetime.date.today()

db=SQLDB('mysql://cookbook:cookbook@127.0.0.1/cookbook')

db.define_table('category',
                Field('name',length=32))

db.define_table('recipe',
                Field('title',length=32),
                Field('description',length=256),
                Field('category',db.category),
                Field('date','date',default=now),
                Field('instructions','text'))

db.category.name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'category.name')]
db.recipe.title.requires=[IS_NOT_EMPTY()]
db.recipe.description.requires=[IS_NOT_EMPTY()]
db.recipe.category.requires=[IS_IN_DB(db, db.category.id, db.category.name)]
db.recipe.date.requires=[IS_DATE()]

but i'm not getting a dropdown box in the category field as supposed to.

any help?

Reply via email to