Re: sql for qualifier that spans two databases

2007-07-18 Thread Travis Britt
On Jul 18, 2007, at 7:04 PM, Art Isbell wrote: Instead, you'll need ask EOF to fetch from the join entity(s) in one DB and do the join in your Java code by fetching from the join entity(s) in the other DB based on the objects fetched from the first DB. Yep! That's what we came to suspect a

Re: sql for qualifier that spans two databases

2007-07-18 Thread Art Isbell
On Jul 18, 2007, at 4:54 AM, Travis Britt wrote: Hoping someone can quickly tell me if this should be possible without writing my own SQL. Two databases. Two EOModels, one for each database. A to-one relationship from an entity in one model to an entity in the other. An EOQualifier is bu

Re: sql for qualifier that spans two databases

2007-07-18 Thread Tonny Staunsbrink
On 7/18/07, Travis Britt <[EMAIL PROTECTED]> wrote: Hoping someone can quickly tell me if this should be possible without writing my own SQL. Two databases. Two EOModels, one for each database. A to-one relationship from an entity in one model to an entity in the other. That is no problem u

sql for qualifier that spans two databases

2007-07-18 Thread Travis Britt
Hoping someone can quickly tell me if this should be possible without writing my own SQL. Two databases. Two EOModels, one for each database. A to-one relationship from an entity in one model to an entity in the other. An EOQualifier is built from a search form that includes attributes o