Re: Simple Select Query

From: Andrey Razumovsky (razumovsky.andre..mail.com)
Date: Tue Aug 25 2009 - 04:09:46 EDT

  • Next message: Null kühl: "Re: Simple Select Query"

    Hi,

    You can use EJBQLQuery for that, something like "select c.name from Client
    c", where Client is a mapped ObjEntity.
    http://cayenne.apache.org/doc/ejbqlquery.html

    Regards,
    Andrey

    2009/8/25 Null kühl <null.kuh..mail.com>

    > I would like to do have a list of of a certain column in a certain table,
    > by
    > sql language that means something like
    >
    > SELECT name FROM `client` c;
    >
    > it's my first time to use cayenne and i searched a lot in it's manual for
    > doing such a query and the only way that was kind of close is writing the
    > query manual , and i believe that this is not the best way to do it.
    >
    > so i was asking about a simple and easy way to do that.
    >
    > also the return of such a query will be a list of clients as List <clients>
    > c; , or since am querying for a certain field it can be something like List
    > <String> names;
    >
    > Please Advice.
    >

    This archive was generated by hypermail 2.0.0 : Tue Aug 25 2009 - 04:10:21 EDT