Re: Simple Select Query

From: Null kühl (null.kuh..mail.com)
Date: Tue Aug 25 2009 - 04:16:43 EDT

  • Next message: Aristedes Maniatis: "Re: Simple Select Query"

    would that query return only the column name from the client table ? also
    the return type will be an object of type client ? is there anyway that i
    can retrieve from this sorta query a list of strings if am querying for a
    name or a list of integers if am querying for a numeral value ?

    On Tue, Aug 25, 2009 at 10:09 AM, Andrey Razumovsky <
    razumovsky.andre..mail.com> wrote:

    > 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:17:30 EDT