<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Exactly what I needed. I *knew* it had to be there.</div><div>Thanks,</div><div>Karen</div><br><div><div>On Sep 17, 2008, at 8:14 PM, Todd Holbrook wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div><div class="gmail_quote">On Wed, Sep 17, 2008 at 12:44 PM, Karen Hoofnagle <span dir="ltr"><<a href="mailto:karen@hoofnagle.org" target="_blank">karen@hoofnagle.org</a>></span> wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I need to perform a whole stack of left outer joins and include data from multiple tables in the results.<br> 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.<br> 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?<br> Here's hoping someone is going to throw me the URL I'm missing and an "RTFM!"<br></blockquote></div><div><br></div>Have a look at the "join_type" attribute on relationships. See the bottom of: <a href="http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Relationship.pm#belongs_to" target="_blank">http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Relationship.pm#belongs_to</a><div> <br></div><div>I've successfully used a join type of "left outer": { join_type => 'left outer' }</div><div><br></div>Todd<br>-- <br>Todd Holbrook<br>Dream Theory Studios<br> </div></div> _______________________________________________<br>List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>IRC: irc.perl.org#dbix-class<br>SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.rawmode.org">http://www.grokbase.com/group/dbix-class@lists.rawmode.org</a></blockquote></div><br></body></html>