No idea why you decided it was appropriate to add some individual
developers to your original email.
The syntax for the HAVING clause in DBIX::Class is documented:-
https://metacpan.org/pod/DBIx::Class::ResultSet#having
You appear to have pasted some straight SQL in, which won't work well.
On 09/03/2016 03:38 AM, Rajeev Prasad 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(
>