Re: How to query a relationship

From: Michael Gentry (blacknex..mail.com)
Date: Thu Feb 15 2007 - 10:06:08 EST

  • Next message: Frank: "Re: How to query a relationship"

    When you were using JDBC, did you have something like a right outer
    join? (An optional relationship?)

    /dev/mrg

    On 2/15/07, Frank <farocc..otmail.com> wrote:
    > Hi Michael,
    >
    > I looked at your tutorial in motion, (it has hellped me understand cayenne
    > better)
    > and have tried setting one to many on the department table.
    >
    > It still fails trying to query department # = 0 and hsp#=5
    > because there is no match in th erelated table.
    >
    > Should I just filter out records where department # is 0?
    > I did not have this problem when I did a jdbc join prior to using cayenne.
    >
    > I am kinda lost at how to resolve this.
    >
    > Regards,
    >
    > Frank
    >
    >



    This archive was generated by hypermail 2.0.0 : Thu Feb 15 2007 - 10:06:45 EST