Re: Ordering by Primary/Foreign Keys

From: Tobias.Schoessle..nvienna.org
Date: Fri Mar 23 2007 - 16:40:14 EDT

  • Next message: Mike Kienenberger: "Re: Ordering by Primary/Foreign Keys"

    I think you have to manually map the fk/pk as an attribute. then cayenne knows the field for ordering.
    when reverse engineering a database cayenne does not create attribute mappings for pks and fks.

    Michael Lepine <mikelepin..mail.com> wrote:
    In my application, I have a few queries that I've created with the
    SelectQuery class. In some instances, I'd like to order the results by the
    primary or foreign keys in the table using the addOrdering() method. I have
    not found a way to do this. I believe I get an error that the column does
    not exist in the ObjEntity instance referenced by the SelectQuery object.

    Maybe I'm approaching this the wrong way. Is there a way to add an "order
    by" clause to a query that includes a primary or foreign key?

    Thanks for your time and any help.

    - Mike

    ___
     sent via WebmailLight 3.1.11

    This archive was generated by hypermail 2.0.0 : Fri Mar 23 2007 - 16:41:14 EDT