I actually just ran the query on my database directly and it failed for that specific CUST_ACCT also.
Thanks for the replies, Kevin Ailes Administrator OTTO Engineering -----Original Message----- From: Ailes, Kevin [mailto:kevin.ailes@;ottoeng.com] Sent: Friday, November 15, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: Row Count failure 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
