On Tue, Jun 19, 2012 at 2:58 PM, Kenneth S Mclane <ksmcl...@us.ibm.com>wrote:
> > Moritz Lenz <mor...@faui2k3.org> wrote on 06/19/2012 01:16:42 PM: > > > It looks like it is because of the relationships limiting the rows > returned. I can comment out the prefetch statement and my extra rows > actually show up. In one case this works fine, in another it causes the > search to fail. I think I may need to create a second rs with just the > related data so if I get a null value I can bypass it. Not sure exactly how > to do this and keep the data straight. Can you share the relevant queries? It may be that you're using an inner join when you need and outer join if you can;t create the related records before the re-query. L. -- lenja...@jaffesystems.com 614-404-4214 www.volunteerable.net Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, Grub Asst: 2008, Trained: 2007.
_______________________________________________ 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.scsys.co.uk