cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Razumovsky <razumovsky.and...@gmail.com>
Subject Re: Simple Select Query
Date Tue, 25 Aug 2009 08:27:51 GMT
Yes, the query I mentioned will return List<String> (and if the objAttrubute
you select is mapped as Integer, it will return List<Integer>). Also you can
specify several columns, then result will be List<Object[]>

2009/8/25 Null kühl <null.kuhl@gmail.com>

> 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.andrey@gmail.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.kuhl@gmail.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.
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message