[Dbix-class] Search_rs not returning newly created rows

[Len Jaffe]

On Tue, Jun 19, 2012 at 2:58 PM, Kenneth S Mclane <ksmclane at us.ibm.com>wrot=
e:

>
> Moritz Lenz <moritz at 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 h=
ow
> 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.

-- =

lenjaffe at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120619/0ef=
18d07/attachment.htm