On Sat, Apr 22, 2006 at 12:30:40PM +0200, Julien Seiler wrote:
> Food(SQLObject):
> name = StringCol()
> brand = StringCol(default=None)
> categories = RelatedJoin("Category")
>
> Category(SQLObject):
> name = StringCol()
> description = StringCol()
> foods = RelatedJoin("Food")
> I would like to query all foods in a given category with a given brand
cat = Category.get(id)
for food in cat.foods: # This fetches ALL foods!
if food.brand = "Gourme":
print food
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
