<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">No idea why you decided it
was appropriate to add some individual developers to your original
email.<br>
<br>
The syntax for the HAVING clause in DBIX::Class is documented:-<br>
<a class="moz-txt-link-freetext" href="https://metacpan.org/pod/DBIx::Class::ResultSet#having">https://metacpan.org/pod/DBIx::Class::ResultSet#having</a><br>
<span>
</span><br>
You appear to have pasted some straight SQL in, which won't work well. <br>
<br>
So you want something along the lines of (untested):-<br>
<div style="margin-left: 40px;" dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13371">my $obj_rs =
$schema->resultset('itemList')->search(<br
id="yui_3_16_0_ym19_1_1472786460498_13413"> { t_id =>
$tStr },<br id="yui_3_16_0_ym19_1_1472786460498_13414"> {<br
id="yui_3_16_0_ym19_1_1472786460498_13415"> group_by
=> [ qw(i_id) ],<br id="yui_3_16_0_ym19_1_1472786460498_13416">
having =>\[ 'count(t_id) = ?', $tCount ],<br
id="yui_3_16_0_ym19_1_1472786460498_13417"> }<br
id="yui_3_16_0_ym19_1_1472786460498_13418"> );</div>
<br>
Nigel.<br>
<blockquote style="border: 0px none;"
cite="mid:486967482.659881.1472866706092@mail.yahoo.com" type="cite">
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="width:100%;border-top:1px solid #EDEEF0;padding-top:5px"> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
<a moz-do-not-send="true" href="mailto:rp.neuli@yahoo.com"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Rajeev Prasad</a></div> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
right;"> <font color="#9FA2A5"><span style="padding-left:6px">3
September 2016 at 02:38</span></font></div> </div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div style="color:#000;
background-color:#fff; font-family:HelveticaNeue, Helvetica Neue,
Helvetica, Arial, Lucida Grande, sans-serif;font-size:14px"><div
dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13314">DBIx error in
webserver log:</div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13379"><br></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13374">[cgi:error] [pid 29640] ...
AH01215: Can't locate object method "HAVING" via package "COUNT"
(perhaps you forgot to load "COUNT"?)</div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13373"><br></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13372"><br></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13369">the query:</div><div
dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13370"><br></div><div
dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13371">my $obj_rs =
$schema->resultset('itemList')->serach(<br
id="yui_3_16_0_ym19_1_1472786460498_13413"> { t_id => {
-in => [ $tStr ] }},<br id="yui_3_16_0_ym19_1_1472786460498_13414">
{<br id="yui_3_16_0_ym19_1_1472786460498_13415">
group_by => [ qw(i_id) ],<br
id="yui_3_16_0_ym19_1_1472786460498_13416"> HAVING
COUNT('t_id') = $tCount<br id="yui_3_16_0_ym19_1_1472786460498_13417">
}<br id="yui_3_16_0_ym19_1_1472786460498_13418">
);</div><div dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13437"><br></div><div
dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13555"><br></div><div
dir="ltr">currently database has no records which match the query. but i
was not expecting such an error.</div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13556"><br></div><div dir="ltr">what
is wrong in my statement?</div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13557"><br></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1472786460498_13558">thank you.</div><div
dir="ltr" id="yui_3_16_0_ym19_1_1472786460498_13569">Rajeev<br></div></div><div>_______________________________________________<br>List:
<a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>IRC:
irc.perl.org#dbix-class<br>SVN:
<a class="moz-txt-link-freetext" href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>Searchable
Archive: <a class="moz-txt-link-freetext" href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a></div></div>
</blockquote>
<br>
<div class="moz-signature">-- <br><pre>[ Nigel Metheringham ------------------------------ <a class="moz-txt-link-abbreviated" href="mailto:nigel@dotdot.it">nigel@dotdot.it</a> ]
[ Ellipsis Intangible Technologies ]
</pre>
<br>
</div>
</body></html>