if (empty record set)

chuleto1 has asked for the wisdom of the Perl Monks concerning the following question:

Monks,
I am trying to execute code when an empty record set is returned from teh database and my code is not doing the job.
Could someone please help me.
I am trying to tell when an empty record set is returned.

my $SQLString "select this, that from there";
$sth = $dbh->prepare($SQLString);
$sth->execute();
@bkmark = $sth->fetchrow;

if(length(@bkmark) == 0)
{
  ...........
}
[download]

-many thanks

Back to Seekers of Perl Wisdom