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 ], -- "The surreality of the universe tends towards a maximum" -- Skud's Law "Never formulate a law or axiom that you're not prepared to live with the consequences of." -- Skud's Meta-Law _______________________________________________ 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