On Fri, 11 Jan 2002 09:07:15 -0500, Terrence Brannon wrote: >> You can do (very portable): >> >> my $sth = $dbh->prepare("SELECT * FROM $table"); > >its a shame that it is not just as portable to limit the result >set to 1 row...
How about 0 rows? my $sth = $dbh->prepare("SELECT * FROM $table where 1=0"); You still have to finish(), though, or otherwise flag DBI/the database that there are no more records, like trying to retrieve a record. -- Bart.