Hi,
My DB tables are as follows -
#########################################################################
# This scaffolding model makes your app work on Google App Engine
too #
#########################################################################
try:
from gluon.contrib.gql import * # if running on Google App
Engine
except:
db=SQLDB('sqlite://db.db') # if not, use SQLite or other
DB
else:
db=GQLDB() # connect to Google
BigTable
session.connect(request,response,db=db) # and store sessions there
#session.forget() # uncomment for no session
at all
#########################################################################
# Define your tables below, for
example #
#
#
# >>>
db.define_table('mytable',SQLField('myfield','string')) #
#
#
# Fields can be
'string','text','password','integer','double','booelan' #
# 'date','time','datetime','blob','upload', 'reference
TABLENAME' #
# There is an implicit 'id integer autoincrement'
field #
# Consult manual for more options, validators,
etc. #
#
#
# More API examples for
controllers: #
#
#
# >>>
db.mytable.insert(myfield='value') #
# >>>
rows=db(db.mytbale.myfield=='value).select(db.mytable.ALL) #
# >>> for row in rows: print row.id,
row.myfield #
#########################################################################
import datetime
now = datetime.date.today()
db.define_table('category',SQLField('name'))
db.define_table('recipe',
SQLField('title'),
SQLField('description',length=256),
SQLField('category',db.category),
SQLField('date','date',default=now),
SQLField('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,'category.id','category.name')]
db.recipe.date.requires = IS_DATE()
However, the dropdown for categories is not coming when trying to add
a recipe. what is the mistake did i do?
regards,
saikat
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
