Possibly dumb question.
I've got a route table with a one 2 many relationship with a location
table. I can see how I can use get_objects with something like:
Route::Manager->get_routes(
query => [
type => 'open',
locations.type => 'start',
locations.name => 'London',
],
with_objects => [ 'locations' ],
);
but 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'.
I can fall back to SQL - but my RDBO sense tells me there is probably
an easier way of doing it...
Am I missing something obvious?
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
