Count the rows as you process them. There is a $sth->rows method, but read the fine manual (perldoc DBI) to see why it isn't a good idea to depend on it for SELECT.
-- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: "Zhao, David [PRDUS Non J&J]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 13:44 Subject: how to get row count using DBI > How can I get row count information from DBI?
