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@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/ _______________________________________________ List: Catalyst@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/