[Catalyst] DBIx question

[Ash Berlin]

1) DBIx is a namespace, not a project.
2) You are talking about DBIx::Class
3)
http://search.cpan.org/~ash/DBIx-Class-0.08006/lib/DBIx/Class.pm#DESCRIPTION
4) Here come the Men in Black
5) Sorry for #4

Will Smith wrote:
> 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.
> <http://us.rd.yahoo.com/evt=48246/*http://autos.yahoo.com/green_center/;_ylc=X3oDMTE5cDF2bXZzBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW4tY2VudGVy>
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> List: Catalyst at lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/