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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---