Hi, Ok, how about this. Show me an example where you can prove the database connection still exists, but you can't fetch rows from $sth on a successful query.. Everytime I have ever had a problem fetching rows, either the query didn't return any, or the dbconnection died.
I guess this might not work with some DBs or drivers? But I have always just used my $returned_rows = $sth->execute(); with mysql DBD::mysql and at least in my case and situation, $returned_rows gives the number of rows returned by the query or 0E0 if nothing. Eric At 07:26 PM 10/24/03 -0700, [EMAIL PROTECTED] wrote: >Let's re-state the question: > >If I can test $dbh using $dbh->ping(), then what is a test for $sth after >the execute command? Assume we don't know if the execute is good or bad >for a SELECT? (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant
