I am new to DBI, so I hope it's not too trivial:
We are trying to read out a blob-field from an Interbase database.
$dbh = DBI->connect($dsn, $USERNAME, $PASSWORD);
$dbh->{LongReadLen}=$max_len;
$sth = $dbh->prepare("SELECT ERID,ERSDESC FROM EVENTREIHE where visible=1
order by erid");
$sth->execute;
while(@rows = $sth->fetchrow_array or die "hallo1:$sth->errstr\n")
{
print"$rows[0]";
print "$rows[1]\n";
}
ERID is an integer and ERSDESC is the blob-field.
This works fine until ERSDESC is null or empty. In this case the following
error message comes up:
DBD::InterBase::st fetchrow_array failed: Row not found for fetch, update or
delete, or the result of a query is an empty table.
-attempted retrieval of more segments than exist
Instead we would like to retrieve only ERID and jump to the next dataset.
Thanks for your help in advance,
Burkhardt
