Hello, when doing this:
(with_objects => [qw(rel_A rel_A.rel_B)], sort_order => 'rel_A.rel_B.field DESC' ) Rose dies with: DBD::mysql::st execute failed: Unknown table 't2.t3' in order clause at /opt/perl/perl-5.8.8/lib/site_perl/5.8.8/Rose/DB/Object/Manager.pm line 1737. It does work with the real table name or with just 'rel_B.field DESC'. But wouldn't 'rel_A.rel_B...' be the safer bet? What if 'rel_A' and 'rel_B' have the same name? Bye, Uwe ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object