Re: Fetching Specified "Raw Rows" with SelectQuery

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun Apr 25 2010 - 04:56:48 EDT

  • Next message: Andrew Lindesay: "Re: Fetching Specified "Raw Rows" with SelectQuery"

    We had this functionality prior to Cayenne 3.0. Now the recommended
    way to specify columns is to use EJBQLQuery instead of SelectQuery. It
    would return either a list of scalars or list of Object[], depending
    on a number of columns in the query. E.g.:

    "select a.artistName from Artist a"

    Andrus

    On Apr 25, 2010, at 4:41 PM, Andrew Lindesay wrote:

    > Hello;
    >
    > The "SelectQuery" has the method "setFetchingDataRows()" which I
    > understand to mean that the query will return a
    > List<org.apache.cayenne.DataRow>.
    >
    > I would also like to specify the attribute properties or similar
    > which I would like to be returned for the query –– is this possible
    > with Cayenne?
    >
    > For those who are also versed with EOF, I would like to do;
    >
    > ...
    > EOFetchSpecification fs = new EOFetc...
    > fs.setFetchesRawRows(true);
    > fs.setRawRowKeyPaths(new NSArray<String>(new String[] { ... }));
    > ...
    >
    > cheers.
    >
    > ___
    > Andrew Lindesay
    > www.silvereye.co.nz
    >
    >



    This archive was generated by hypermail 2.0.0 : Sun Apr 25 2010 - 04:57:21 EDT