thanks a ton. i guess i was thinking too much in sql terms-- i had to add a bunch more relationships as rose metadata
> The Manager interface is designed to allow people to think only in > terms of > objects and relationships. If you think in SQL instead, you just > need to > know what SQL is generated for each Manager param. In this case, > you'd need > to know that with_objects => [ ... ] causes the table for the class > of each > listed relationship to be LEFT JOINed, with the join conditions > pulled from > the relationship definitions. After that, it's just a matter of > defining > the right relationships and stringing them together with dots in > the right > places in the Manager call. That was key. thanks. i read through the source, experiemented a bit, and got a good feel on the sql that is generated- then i reverse engineered my query. works like a charm. ------------------------------------------------------------------------- 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 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
