Exactly what I needed. I *knew* it had to be there.
Thanks,
Karen
On Sep 17, 2008, at 8:14 PM, Todd Holbrook wrote:
On Wed, Sep 17, 2008 at 12:44 PM, Karen Hoofnagle
<[EMAIL PROTECTED]> wrote:
I need to perform a whole stack of left outer joins and include data
from multiple tables in the results.
I've found the from clause documentation in ResultSet, so I know I
can force my own join setup if I must, but the docs do point out
that this is subverting the framework and should only be used after
you've exhausted the in-framework options.
Have I just completely missed something in the documentation? How
does one set up a left outer join within the usual working
constraints of DBIX::Class?
Here's hoping someone is going to throw me the URL I'm missing and
an "RTFM!"
Have a look at the "join_type" attribute on relationships. See the
bottom of: http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Relationship.pm#belongs_to
I've successfully used a join type of "left outer": { join_type =>
'left outer' }
Todd
--
Todd Holbrook
Dream Theory Studios
_______________________________________________
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/[EMAIL PROTECTED]
_______________________________________________
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/[EMAIL PROTECTED]
