On 27 May 2007, at 18:31, Paul Makepeace wrote:
I notice adding a prefetch to a search causes some results to go
missing in the case that the column being joined on is null in the
first table. This is down to prefetch using an inner rather than left
join. Presumably y'all had a reason for that? The left join solved it
for me (in SQL tests). Is there a work-around for this?
You can change the join type used in a relationship - see the
join_type attribute in the DBIx::Class::Relationship::Base
documentation (near the top of the page).
Nigel.
--
[ Nigel Metheringham [EMAIL PROTECTED] ]
[ - Comments in this message are my own and not ITO opinion/policy - ]
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
