Adrian Howard wrote on 6/13/07 7:40 AM: > 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? >
have you read http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.764/lib/Rose/DB/Object/QueryBuilder.pm I think you just want to 2 locations.name params. -- Peter Karman . http://peknet.com/ . [EMAIL PROTECTED] ------------------------------------------------------------------------- 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
