Order By using related objects

[prev] [thread] [next] [Date index for 2005/04/13]

Hi all, I come again to you seeking help. Have any of you tried
something like this, and what is the best way?

First, I'm filling array with the results of a search:

my @vendors = express::DBI::VendorCat->search(catid=>$catid);

But I want the array to be sorted by the name of the vendor. The name of
the vendor is found through a pointer from VendorCat. I want to sort by
express::DBI::VendorCat::vndrid->busname. 

my @vendors =
Conquent::Parser::express::DBI::VendorCat->search(catid=>$catid,
{ order_by=>'vndrid->busname' }); 

But that doesn't seem to me that it would work. Is it possible to do
this with the order_by argument? Or should I just sort it after I've
filled the array?

Thanks,
d. Taylor SIngletary