When I did go looking for the join_type syntax I went to <a href="http://Relationship.pm">Relationship.pm</a> and from there was referred to Relationship/Base.pm which contained the answer.<br><br>I'd like to have seen something in the cookbook under the 'Using joins and prefetch
<span style="text-decoration: underline;"><span style="text-decoration: underline;"></span></span>' section. I know this doesn't really make sense when you know that it's the relationship that you need to change but it is intuitively where I'd look if I were a newbie. Something along the lines of 'To specify different join types see :
<a href="http://search.cpan.org/%7Emstrout/DBIx-Class-0.06000/lib/DBIx/Class/ResultSource.pm" class="podlinkpod">DBIx::Class::Relationship::Base</a>' at the end of the joins and prefetch section would suffice. I do accept that DBIx::Class is big and not everything can go in the cookbook which is already big.
<br><br>Basically, if you wanted to change the join type and didn't know what you were doing you'd probably look for the stuff on joins, not the stuff on relationships.<br><br><div><span class="gmail_quote">On 4/3/06, <b class="gmail_sendername">
Will Hawes</b> <<a href="mailto:info@whawes.co.uk">info@whawes.co.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
luke saunders wrote:<br>> You're dead on Will - that makes it work perfectly.<br>><br><br>Good to hear.<br><br>It took me a few minutes to track down the docs for the join_type<br>attribute (in ResultSource.pm). I think it's an area that could be
<br>documented better and will look at improving things. To that end it<br>would be interesting to hear which docs you read before posting, i.e.<br>where you would have expected to find the answer.<br><br>_______________________________________________
<br>List: <a href="http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class">http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class</a><br>Wiki: <a href="http://dbix-class.shadowcatsystems.co.uk/">http://dbix-class.shadowcatsystems.co.uk/
</a><br>IRC: irc.perl.org#dbix-class<br>SVN: <a href="http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/</a><br></blockquote></div><br>