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.
