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