Re: [Dbix-class] DBIx HAVING and COUNT error

2016-09-03 Thread Nigel Metheringham
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.

Re: [Dbix-class] DBIx HAVING and COUNT error

2016-09-03 Thread Stefan Hornburg (Racke)
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( >