Rosers,
Have a bit of trouble with a Manager query. Trying to keep it short and
sweet, I am searching a table "orders" which has a onetoone relationship
called destaddress. The first 3 queries here work:
push @query, ('custlastname' => {like => '%smith%'});
push @query, ('destaddress.primecontact' => {like => '%smith%'});
push @query, (or => ['custlastname' => {like => '%smith%'}]);
but when the subtable query is put in the "OR" array viz:
push @query, ('or' => ['destaddress.primecontact' => {like => '%smith%'}]);
it fails with:
Invalid query parameter: destaddress.primecontact at oprosemgord.pl line 991
at C:/Perl/site/lib/Rose/DB/Object/QueryBuilder.pm line 132
Am I doing something stupid or can one not do relationships within an "or"
query?
thanks for any advice,
James Masters.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
