[Catalyst] DBIx question

[Will Smith]

Hi, I know this is not the room for DBIx, I tried to post in DBIx, but did not go through, so, if you don't mind, please do not bounce me out.
 my question is:
 I have a multiple join, and trying to sort the dataset using oder_by, and get either error, or do not sort.
 my code is:
     # table: calls,property,city . property has many calls, city has many property,   calls belong to property, property belong to city
     my $rs = [$c->model('myappDB::City')->search(
     {
       'calls.CallerID' => '1',
       'calls.CallStatusID' => '0'
     },
     {
        order_by => 'city.CityName'
     },
     {
       join => { 'property' => 'calls'
                }
     }
     )];
 
 How can I sort by CityName ?
 
 Thank you.
 
       
---------------------------------
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070824/9bbb9808/attachment.htm