On Tue, Sep 6, 2016 at 5:01 AM, Dagfinn Ilmari Mannsåker <ilm...@ilmari.org> wrote:
> Len Jaffe <lenja...@jaffesystems.com> writes: > > > On Sun, Sep 4, 2016 at 11:13 PM, Rajeev Prasad <rp.ne...@yahoo.com> > wrote: > >> having => { 'count 1' => $tCount }, > > having => { 'count(1)' => $tCount }, > > That breaks if you enable name quoting, as the hash keys are interpreted > as column names. You can use the arrayrefref syntax for arbitrary SQL > with placeholders: > > having => \['count(1) = ?', $tCount ], > Yup. My point however was the lack of valid 'count' syntax in the having has key/value. -- Len Jaffe - Information Technology Smoke Jumper - lenja...@jaffesystems.com 614-404-4214 @LenJaffe <https://www.twitter.com/lenJaffe> www.lenjaffe.com Host of Code Jam Columbus <http://www.meetup.com/techlifecolumbus/> - @CodeJamCMH <https://www.twitter.com/CodeJamCMH> Curator of Advent Planet <http://www.lenjaffe.com/AdventPlanet/> - An Aggregation of Online Advent Calendars.
_______________________________________________ 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