Hi,
I have been faced with a problem that is mindboggling, and I do not know how to
further pursue it.
Setup:
maxdb 7.600.12 DBD::Maxdb 7.6.00.16, SUSE 9.3, Perl 5.8.6 as it came on Suse
The program that I have this problem with has 4 statement handles open that
are used sequentially.
In the snippet shown below, for every item ($artno, [varchar]) retrieved
from another handle,
further information is selected in a sub from a second table (unterreihen).
This works as intended for the first 8 items (artnos),
but after that no further results
are retrieved from the unterreihen table, although records for the correspoding
artnos are DEFINITELY contained in the unterreihen table.
What puzzles me most, is that data for the first 8 items are retrieved, and
after that no records are retrievable from the unterreihen table.
I'd appreciate any pointers on how to pursue solving this problem, especially
as to WHERE to look (maxdb, DBD-MAXDB?, Perl.)
A dbi trace can be made available.
---------------- in a sub--------------------------------------
my $unterreihen_query="select
REIHENID,L1DATA,L2DATA,L3DATA,L4DATA from
unterreihen where artno = ? ";
$sth_unterreihe = $dbh->prepare_cached($unterreihen_query)
|| die $dbh->errstr;
my $artno=$x{ARTNO};
my $rc = $sth_unterreihe->execute(($artno)) || die $dbh->errstr;
my $err=$sth_unterreihe->errstr;
print STDERR "get_unter_data: $artno: RC=$rc $err\n";
while ($ret= $sth_unterreihe->fetchrow_hashref ) {
my $reihenid=$$ret{REIHENID};
$ur_hash{$$ret{REIHENID}}=$ret;
print STDERR "--->got $artno $reihenid\n";
}
-----------------------------------------------------------------
-walt obermiller
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
