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.k...@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.and...@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.k...@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. > > > > > >
