Hello SQLObject and friends,
If I have the two classes:
class Product(InheritableSQLObject):
name = StringCol(length=255, alternateID=True)
description = StringCol()
archived = BoolCol(default=False)
options = RelatedJoin('ProductOption', orderBy="name")
class ProductOption(SQLObject):
name = StringCol(alternateID=True, length=255)
archived = BoolCol(default=False)
products = RelatedJoin('Product', orderBy="name")
I want to get all products that are not archived of a given product option.
So how can I emulate this using a SQLBuilder and preferably without
mention of product_product_option?
SELECT * FROM product, product_product_option WHERE product.id =
product_product_option.product_id AND
product_product_option.product_option_id = 2 AND product.archived = 0;
Thanks in advance,
-Ian
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
