perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Landwehr <>
Subject OT: DBI does not return all records?
Date Wed, 08 Mar 2000 09:38:40 GMT
I use DBI to query a Sybase DB and display the results with
Embperl like in the following codesegment:
<SELECT name="subject" size=1 class="normal">
		$strSQL = "SELECT name FROM vbmg006";
		$sth = $dbh->prepare($strSQL);
		while ($recordset = $sth->fetchrow_hashref) {
								print "<OPTION value=\"$recordset->{id}\">$recordset->{name}";

Unfortunately sometimes only 3 (and it's everytime exactly 3!) of
the expected 10 or so rows get displayed. Since I experience this
behaviour for the 3rd time now I thought I'd ask here if someone
experienced a similar thing and if there is a fix/workaround for
it. The error seems to happen somewhere in DBI since a
$dbh->trace shows me that only 3 rows are returned to my script.


View raw message