<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Sep 6, 2016 at 5:01 AM, Dagfinn Ilmari Mannsåker <span dir="ltr"><<a href="mailto:ilmari@ilmari.org" target="_blank">ilmari@ilmari.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Len Jaffe <<a href="mailto:lenjaffe@jaffesystems.com">lenjaffe@jaffesystems.com</a>> writes:<br>
<br>
> On Sun, Sep 4, 2016 at 11:13 PM, Rajeev Prasad <<a href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>> wrote:<br>
>> having => { 'count 1' => $tCount },<br>
> having => { 'count(1)' => $tCount },<br>
<br>
That breaks if you enable name quoting, as the hash keys are interpreted<br>
as column names. You can use the arrayrefref syntax for arbitrary SQL<br>
with placeholders:<br>
<br>
having => \['count(1) = ?', $tCount ],<br></blockquote><div><br></div><div>Yup. My point however was the lack of valid 'count' syntax in the having has key/value.</div><div><br></div><div><br></div><div> </div></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Len Jaffe - Information Technology Smoke Jumper - <a href="mailto:lenjaffe@jaffesystems.com" target="_blank">lenjaffe@jaffesystems.com</a> </div><div>614-404-4214 <a href="https://www.twitter.com/lenJaffe" target="_blank">@LenJaffe</a> <a href="http://www.lenjaffe.com/" target="_blank">www.lenjaffe.com</a><br></div><div>Host of <a href="http://www.meetup.com/techlifecolumbus/" target="_blank">Code Jam Columbus</a> - <a href="https://www.twitter.com/CodeJamCMH" target="_blank">@CodeJamCMH</a></div><div><div>Curator of <a href="http://www.lenjaffe.com/AdventPlanet/" target="_blank">Advent Planet</a> - An Aggregation of Online Advent Calendars.<div><br></div></div></div></div></div></div></div></div></div>
</div></div>