You start fetching after the execute.
prepare(...)
execute(...)
while (any fetch method)
{
In here mean that at least one row has been returned, you can also keep a
counter of how many rows are returned, or rely on the driver dependent
$dbh->rows(); method.
}
Ilya
-----Original Message-----
From: Paul Maine Jr.
To: DBI Users Perl. Org (E-mail)
Sent: 9/10/01 1:39 PM
Subject: Perl DBI Question
I am writing a Perl/DBI application. I need to initially issue a select
statement and then determine if any records are returned. Could someone
provide me with an example of how to determine if no records are
returned
from a select statement.
Thank You
