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 < [email protected]> 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 <[email protected]> > > > 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. > > >
