[Dbix-class] Getting a' count' value

[Chris Cole]

Emmanuel Quevillon wrote:
> Peter Rabbitson wrote:
>> Emmanuel Quevillon wrote:
>>> Hi,
>>>
>>> Sorry if my question looks stupid, but I'd like to retrieve the
>>> value of a count returned by an SQL query.
>>>
>>> I tried different things but it always return 1
>>>
>>> Here is the way I'd like it to work:
>>>
>>> ...
>>> acc => $g->name(),
>>> num => $c->model('Table')->search({'id' => $g->id},<CODE>
>>>
>>> where I tried to replace <CODE> with :
>> Ever tried search()->count ? :)
> 
> Hi Peter,
> 
> Yep, I forgot to mention it, but I also tried this solution
> with the same results -> cnt = 1.
> I also tried something else, when I change the column name that
> returns a count of 0, I also get a value of 1 as value in my hash
> table $hash->{num}
> Weird!!

You don't show the exact code, but I suspect this is a perl issue. The
code is returning a list, but you're expecting a scalar therefore only
ever get '1' i.e. a list of one.

Either, fix the code to return a scalar or to accept a list. e.g. try an
array rather than a hash.