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
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_
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.