[Dbix-class] Getting a' count' value

[Moritz Onken]

Am 14.05.2009 um 14:16 schrieb Emmanuel Quevillon:

> 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 :
>
> 1- )->all()
> 2- { select =>[{'count' => '*'}],as => ['cnt']
> })->next->get_column('cnt')
>
> But each time, $hash->{num} =  1!
>
> The SQL request are well generated in each case :
>
> SELECT COUNT( * ) FROM Table me WHERE ( id = '1012' ):
> SELECT COUNT( * ) FROM Table me WHERE ( id = '296' ):
>
>
>
> What am I doing wrong?

There only is one row with the id 1012 resp. 296?
What are you trying to achieve?