Say, I have two tables: vendors and products. Now I want a list of all the vendors that have no products yet. This can be seen from the products table if there are no records with the vendor_id of the vendor in question. Is this possible with a 'normal' manager method or with a relationship or do I have to hand-code the SQL?
And if I have to hand-code it with get_objects_from_sql -- can you give me a hint, what would be a good (fast, portable) SQL to do this kind of query (my SQL isn't that good). And how can I make the resulting method a method of my "Vendors" class (I don't use separate manager classes)? Thanks, Michael ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object