<br><tt><font size=2>Moritz Lenz <moritz@faui2k3.org> wrote on 06/19/2012
01:16:42 PM:<br>
<br>
> From:</font></tt>
<br><tt><font size=2>> <br>
> Moritz Lenz <moritz@faui2k3.org></font></tt>
<br><tt><font size=2>> <br>
> To:</font></tt>
<br><tt><font size=2>> <br>
> dbix-class@lists.scsys.co.uk</font></tt>
<br><tt><font size=2>> <br>
> Date:</font></tt>
<br><tt><font size=2>> <br>
> 06/19/2012 01:20 PM</font></tt>
<br><tt><font size=2>> <br>
> Subject:</font></tt>
<br><tt><font size=2>> <br>
> Re: [Dbix-class] Search_rs not returning newly created rows</font></tt>
<br><tt><font size=2>> <br>
> On 06/19/2012 05:27 PM, Kenneth S Mclane wrote:<br>
> > I have succeeded in creating a new row in my table with "->create".
I<br>
> > then go back to my page that lists all the rows in that table,
and I get<br>
> > the list using "search_rs", but the newly created rows
are not showing.<br>
> > I verified that the rows do exist. I'm not sure why this isn't
working.<br>
> <br>
> Maybe an uncommitted transaction somewhere?<br>
> Does your database have the facility to list open transactions? If
yes,<br>
> do that while the program is running; maybe you'll find something
of<br>
> interest.<br>
> <br>
> Cheers,<br>
> Moritz<br>
> <br>
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.<br>
</font></tt>