There must a better way that this but ...

Rk::M->set_sql(maxid => q(select max(m) from m));
my $max = +(Rk::M->search_maxid)[0]->{'max(m)'};
[download]

But that breaks encapsulation rather blatantly. Since Class::DBI is really about the mapping of tables to classes (roughly) it's probably a better idea just to drop into raw DBI e.g

my $max = $dbh->selectrow_array('select max(m) from m');
[download]

HTH

_________
broquaint