Re: DBIx HAVING and COUNT error

Hi Rajeev

On 03/09/16 11:38, Rajeev Prasad via dbi-users wrote:
> DBIx error in webserver log:
>
> [cgi:error] [pid 29640] ... AH01215: Can't locate object method "HAVING"
> via package "COUNT" (perhaps you forgot to load "COUNT"?)
>
>
> the query:
>
> my $obj_rs = $schema->resultset('itemList')->serach(
>                 { t_id => { -in => [ $tStr ] }},
>                 {
>                     group_by => [ qw(i_id) ],
>                     HAVING COUNT('t_id') = $tCount

What is this? The syntax you have used is simple not Perl.

I did not check the manual, but try (wild guess):

                      "having count('t_id')" => $tCount,

>                 }
>             );
>
>
> currently database has no records which match the query. but i was not
> expecting such an error.
>
> what is wrong in my statement?
>
> thank you.
> Rajeev

-- 
Ron Savage - savage.net.au