Re: Re: Sqlite DBI $sth->rows

I'm not quite sure what you mean by "proactively", but this deals with the case of no rows found ...

my $dbh = DBI->connect($conn_string, $user, $password,
{
    RaiseError => 1,
}) || die $DBI::errstr;

my $sth = $dbh->prepare(<<__END_SQL__);
SELECT stuff
  FROM some_place
 WHERE some_condition = 1
__END_SQL__

$sth->execute;

my $num_rows = 0;
while (my @x = $sth->fetchrow)
{
    $num_rows++;
    do_something_with(@x);
}

die "No rows found\n" unless $num_rows;

print "Done\n";
[download]

------
We are the carpenters and bricklayers of the Information Age.

The idea is a little like C++ templates, except not quite so brain-meltingly complicated. -- TheDamian, Exegesis 6

... strings and arrays will suffice. As they are easily available as native data types in any sane language, ... - blokhead, speaking on evolutionary algorithms

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

Comment on Re: Re: Sqlite DBI $sth->rows Download Code