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 ------------------------- _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk