How To Use DBIx::SQLEngine To Get A Count

Author: erics, Posted May 11th, 2011 at 12:39:08pm

my $value    = $dbh->fetch_one_value(
   'table' => 'users',
   'columns' => 'COUNT(*)',
   'where' => {
      'active' => 1,
   },
);

my $value = $dbh->fetch_one_value(

'table' => 'users',

'columns' => 'COUNT(*)',

'where' => {

'active' => 1,

);

All fields marked with "*" are required.