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
-~----------~----~----~----~------~----~------~--~---

Reply via email to