Re: many-to-many query question

On Oct 26, 2007, at 11:32 AM, James Cicenia wrote: Well actually I didn't.. I just brought in the source and compiled it. And you expected it to work? :-) See com.houdah.webobjects.eoaccess.PrincipalClass for why it does not. By the way I also tried Lachlan's version and that didn't se

Re: many-to-many query question

Well actually I didn't.. I just brought in the source and compiled it. By the way I also tried Lachlan's version and that didn't seem to generate a real IN or CONTAINS clause in the sql so the it always returns 0 rows. Here is the generated sql: FROM portfolio_project t0, portfolio_metric_li

Re: many-to-many query question

Without information on how you are using it and the model, you leave us guessing. Well, as I am left guessing, I guess that the framework is not getting initialized correctly. Did you add the framework like a normal WO framework? Chuck On Oct 26, 2007, at 7:16 AM, James Cicenia wrote:

Re: many-to-many query question

On Oct 25, 2007, at 8:59 PM, Lachlan Deck wrote: On 26/10/2007, at 12:47 PM, Chuck Hill wrote: On Oct 25, 2007, at 6:29 PM, Lachlan Deck wrote: On 26/10/2007, at 10:40 AM, James Cicenia wrote: I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItems

Re: many-to-many query question

Ok - I tried the ExistsInRelationshipQualifier but I get this error: (class com.houdah.webobjects.eocontrol.ExistsInRelationshipQualifier (does not implement EOQualifierSQLGeneration at com.webobjects.eoaccess.EOQualifierSQLGeneration $Support._schemaBasedQualifierWithRootEntity (EOQualifie

Re: many-to-many query question

On 26/10/2007, at 12:47 PM, Chuck Hill wrote: On Oct 25, 2007, at 6:29 PM, Lachlan Deck wrote: On 26/10/2007, at 10:40 AM, James Cicenia wrote: I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject How I can create a query w

Re: many-to-many query question

On Oct 25, 2007, at 6:29 PM, Lachlan Deck wrote: On 26/10/2007, at 10:40 AM, James Cicenia wrote: I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject How I can create a query where project can have ( Items(a) OR Items(b) )

Re: many-to-many query question

On 26/10/2007, at 10:40 AM, James Cicenia wrote: I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject How I can create a query where project can have ( Items(a) OR Items(b) ) AND (Items(c)) Something like this... NSMutableA

Re: many-to-many query question

great.. they look perfect. I thought I remembered there being something like that out here. On Oct 25, 2007, at 7:58 PM, Chuck Hill wrote: I just copied that from his Blog :-) Maybe it is not ready. The originals are here: http://www.bernard-web.com/pierre/webobjects/code.html On Oct 25

Re: many-to-many query question

I just copied that from his Blog :-) Maybe it is not ready. The originals are here: http://www.bernard-web.com/pierre/webobjects/code.html On Oct 25, 2007, at 5:55 PM, James Cicenia wrote: Hmmm,,, That sounds right.. but there are no files there ? On Oct 25, 2007, at 7:48 PM, Chuck Hil

Re: many-to-many query question

Hmmm,,, That sounds right.. but there are no files there ? On Oct 25, 2007, at 7:48 PM, Chuck Hill wrote: On Oct 25, 2007, at 5:40 PM, James Cicenia wrote: Hello - I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject Ho

Re: many-to-many query question

On Oct 25, 2007, at 5:40 PM, James Cicenia wrote: Hello - I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject How I can create a query where project can have ( Items(a) OR Items(b) ) AND (Items(c)) or even (items(a) or item

many-to-many query question

Hello - I have a many-to-many relationship as such: Portfolio --->>MetricGroups--->>MetricItemsProject How I can create a query where project can have ( Items(a) OR Items(b) ) AND (Items(c)) or even (items(a) or items(b) or ... items(x)) AND (items (c) or items(d)) AND