On Mar 3, 2008, at 11:05 PM, Michael Gentry wrote:
I could be mistaken here, but I don't believe that Expression.fromString() supports "select...".
Exactly. The closest thing it resembles is EJBQL syntax [1]. But that would require Cayenne 3.0 and a different type of query - EJBQLQuery.
Andrus [1] http://cayenne.apache.org/doc/ejbqlquery.html
