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. -John ------------------------------------------------------------------------- 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
