I get an error when I attempt a query for a specific CUST_ACCT using code
like this....
---------------
my $sth = $dbh->prepare("select * from CHSTX_WEB_INVOICE where
CUST_ACCT = $quotedcust_no ORDER BY SASH_VAL DESC")
or die "Can't prepare SQL statement: $DBI::errstr\n";
---------------
The error looks like this in the apache web server log file....
---------------
[Fri Nov 15 11:12:52 2002] [error] [client 10.10.0.66] DBD::ODBC::st
fetchrow_array failed: [Ardent][SQL Client][RPC] error code = 81001
(SQL-IM985)(DBD: finish/SQLFreeStmt(SQL_CLOSE) err=-1) at
F:/Perl/lib/webflosub.pl line 1108.
---------------
This particular CUST_ACCT number happens to have ~17,000 rows total in the
file. All other customers are below 10,000 rows.
I am pretty new to this type of programming, but this appears to be erroring
at the datasource level. Has anyone seen this before? Is there something I
can set in DBI to overcome this apparent limit?
Thanks for any replies.
Kevin Ailes
Administrator
OTTO Engineering
