<br>
<br><tt><font size=2>Len Jaffe <lenjaffe@jaffesystems.com> wrote
on 06/19/2012 04:29:53 PM:<br>
<br>
> From:</font></tt>
<br><tt><font size=2>> <br>
> Len Jaffe <lenjaffe@jaffesystems.com></font></tt>
<br><tt><font size=2>> <br>
> To:</font></tt>
<br><tt><font size=2>> <br>
> "DBIx::Class user and developer list" <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 04:32 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>
> <br>
</font></tt>
<br><tt><font size=2>> On Tue, Jun 19, 2012 at 4:57 PM, Kenneth S Mclane
<ksmclane@us.ibm.com> wrote:</font></tt>
<br><tt><font size=2>> Len Jaffe <lenjaffe@jaffesystems.com> wrote
on 06/19/2012 03:45:34 PM:<br>
> <br>
> > <br>
> Strangely, I found that without the prefetch I am getting all the
<br>
> data, it's just that the columns are null as you said. It seems to
<br>
> do the left outer join when left to it's own devices. I can still
<br>
> access the fields in the related tables from my templates. I just
<br>
> added some template code to compensate for the null fields.<br>
</font></tt>
<br><tt><font size=2>> I an saddened by the fact that you're making
database calls from <br>
> your templates. </font></tt>
<br><tt><font size=2>> I am consoled by the fact that I don't have to
support it :-) </font></tt>
<br><tt><font size=2>> Glad we could find a solution.</font></tt>
<br><tt><font size=2>> L.</font></tt>
<br><tt><font size=2>> <br>
> -- <br>
> lenjaffe@jaffesystems.com 614-404-4214
</font></tt><a href=www.volunteerable.net><tt><font size=2>www.volunteerable.net</font></tt></a>
<br><tt><font size=2>> Proprietor: </font></tt><a href=http://www.theycomewithcheese.com/><tt><font size=2>http://www.theycomewithcheese.com/</font></tt></a><tt><font size=2>
- An Homage to Fromage</font></tt>
<br><tt><font size=2>> Greenbar: Grubmaster: 2012-2009, Grub
Asst: 2008, Trained: 2007.</font></tt>
<br><tt><font size=2>> <br>
Wow, way to jump to a conclusion. I am not making a DB call from my template,
I just added an IF so if the field is null it displays a "0"
instead of nothing, just a readability issue. :-)</font></tt>