On 13 Jun 2007, at 14:33, John Siracusa wrote: > On 6/13/07, Adrian Howard <[EMAIL PROTECTED]> wrote: >> I can't see how to get_routes that have a relation ship to both a >> location with a name of 'London' and another with a name of >> 'Brighton'. > > Off the top of my head, this seems like you'd need two "EXISTS (...)" > subqueries to do this. To use subqueries in a Manager call, you > currently have to specify them as hard-coded SQL, either using the > "clauses" parameter or by passing scalar refs in the query parameter.
Ah! clauses should do it. I knew there had to be a simple way. Many thanks. Adrian ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
