Re: [RDBO] limiting a result set including 2 unrelated objects

2006-09-18 Thread John Siracusa
On 9/18/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > the problem is that i need to limit a query to where > > a.1.b.1.FIELD = a.2.a.1.a.FIELD Have you tried using eq_sql? 'a.1.b.1.FIELD' => { eq_sql => 'tN.FIELD' }, -John

Re: [RDBO] limiting a result set including 2 unrelated objects

2006-09-18 Thread Jonathan Vanasco
On Sep 18, 2006, at 3:31 PM, Jonathan Vanasco wrote: > a.1.b.1.FIELD = a.2.a.1.a.FIELD > > rose doesn't seem to support this outright > > anyone have a clue how i can coerce this? Sorry, I forgot to add that this is within a nested conditonal WHERE ( a.1.b.1.FIELD_

[RDBO] limiting a result set including 2 unrelated objects

2006-09-18 Thread Jonathan Vanasco
i have a rather complex object query that pulls in 8 rose db objects during a manager query it kind of looks like this: a.1.b.1 a.1.a a.1 a a.2 a.2.a a.2.a.1 a.2.a.1.