I do not understand. Can you do an example of what you want?
Without understanding I can see something is missing:
> db.define_table('notebook',
> SQLField('name'))
>
> db.define_table('entry',
> SQLField('title'),
> SQLField('notebook',db.notebook))
db.entry.notebook.requires=IS_IN_DB(db,'notebook.id','%(name)s')
> def entries():
> #return the notebook itself
> records=db(db.entry.notebook==request.vars.notebook)\
> .select(orderby=~cdb.entry.id)
# you do not need the select for the rest to work
> form=SQLFORM(cynotedb.entry,fields=['notebook'])
if form.accepts(request.vars,session):
session.flash='record inserted'
redirect(URL(r=request)) # or somewhere else
> return dict(form=form, records=records)
On Jan 28, 9:34 pm, MadWalker <maddalwal...@gmail.com> wrote:
> is it able to do a joint table entries selection?
> by only selecting only those that i need but still having those
> database stored
> and not delete it away?
>
> the table database and code are listed as
>
> db.define_table('notebook',
> SQLField('name'))
>
> db.define_table('entry',
> SQLField('title'),
> SQLField('notebook',db.notebook))
>
> def entries():
> #return the notebook itself
> records=db(db.entry.notebook==request.vars.notebook)\
> .select(orderby=~cdb.entry.id)
> form=SQLFORM(cynotedb.entry,fields=['notebook'])
> return dict(form=form, records=records)
>
> if there are 3 notebook, instead of letting it list out the one that i
> dun want in the notebook itself,
> is it able to do a selection?
> but still letting the database itself be delete?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
