On Fri, Aug 21, 2009 at 4:22 PM, Steve Rippl<rip...@woodlandschools.org> wrote: > Now the following in my app > > $c->stash->{sections} = [$c->model('DB::Section')->search( > {}, > { > join => [{'course_sections' => 'courses'} , > {'staff_sections' => 'staffs'}], > order_by => ['courses.grade', > 'staffs.name_last'], > prefetch => [{'course_sections' => > 'courses'} , {'staff_sections' => 'staffs'}], > })];
Are you sure that the rel between 'course_sections' class and 'courses' class is a belongs_to (or a proper add_relationship setup), as well between 'staff_sections' class and 'staffs' class? If so, report with a failing test case. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Developer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk