Re: How do I get a single resultset back using Cayenne

From: Michael Gentry (blacknex..mail.com)
Date: Sun Feb 04 2007 - 18:04:51 EST

  • Next message: Andrus Adamchik: "Re: subclassing standard Java types"

    You are essentially wanting a "select * from Procedure"?

    /dev/mrg

    On 2/4/07, Frank Rocco <farocc..otmail.com> wrote:
    >
    > Hello,
    >
    > I need to display a table that shows all procedures with a column that says
    > if there is a schedule for the current date and what provider is assigned.
    >
    > Procedure Table
    > procedure_id (PK)
    > procedure_name
    >
    > Provider Table
    > provider_id (PK)
    > provider_name
    >
    > Schedule Table
    > schedule_id (PK)
    > schedule_date
    > procedure_id (FK)
    > provider_id (FK)
    >
    > I need to display all procedures regardless if there is a record in the
    > provider or procedure table.
    > Before Cayenne, I was using JDBC to build a List of records that I asssigned
    > to a Click Table.
    >
    > I am trying to redo this in Cayenne.
    > Am I on the right track or does Cayenne allow me to redesign this?
    >
    > Regards,
    >
    > Frank Rocco
    > farocc..otmail.com
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Sun Feb 04 2007 - 18:05:19 EST