[Dbix-class] Outer Joins

[Karen Hoofnagle]

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  
> <karen at hoofnagle.org> 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/dbix-class@lists.rawmode.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20080918/8cbc3491/attachment.htm