Hello all.
I've got some news categories:
db.define_table('news_categories',
Field('name', type='string', requires=IS_NOT_EMPTY(), label=
'Nome'),
format = '%(name)s')
And some news:
db.define_table('news',
Field('title', type='string', requires=IS_NOT_EMPTY()),
Field('body', type='text''),
Field('category', 'reference news_categories', requires =
IS_IN_DB(db, db.news_categories.id,'%(name)s'),
represent=lambda id, r: db.news_categories[id].name))
How can I select only the news_categories that have almost one news of that
category ?
Now I've got all categories.
categories=db().select(db.news_categories.ALL)
Thanks.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
