in reply to Determining if a DBI SELECT comes back empty
Not all DBDs set the statement handle before a fetch, but MySQL does. That means that you don't have to fetch *any* rows. For a purposefully verbose example:
Note that the finish() is required here because you do no fetching. If one of the if's had a fetch, you'd omit the finish().if (my $rows = $sth->execute) { if ($rows==0) { print "Zero rows returned"; } else { print "$rows rows returned"; } } else { print "Failed execute: ". $sth->errstr; } $sth->finish;
--
The heck with patents, here's how to protect your thoughts: <tinfoil>.o0(Martians can't read this)</tinfoil>
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Determining if a DBI SELECT comes back empty
by tantarbobus (Hermit) on Dec 05, 2003 at 22:43 UTC |
In Section
Seekers of Perl Wisdom