Re: DBIx HAVING and COUNT error
Ron Savage <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Rajeev
On 03/09/16 15:58, Rajeev Prasad wrote:
> I tried what you said and also what manual says, but it is not working....
> my tries:
> HAVING => { count('t_id') => $tCount}
> HAVING => {'COUNT_t_id' => {'=', $tCount } }
> HAVING => { count('t_id') => {'=', $tCount } }
>
> having => { 'count_employee' => { '>=', 100 } }
Those docs tell me that the SQl has to include something like:
'select ... count(t_id) as count_t_id ...
And then the having can be
having => {count_t_id => {'=', $tCount} }
--
Ron Savage - savage.net.au