[Dbix-class] Getting a' count' value

[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?
Any advice welcome

Regards

-- 
-------------------------
Emmanuel Quevillon
Biological Software and Databases Group
Institut Pasteur
+33 1 44 38 95 98
tuco at_ pasteur dot fr
-------------------------