|| at Dec 10, 2004 at 6:43 am
On Thu, 2004-12-09 at 23:03, David Goodman wrote:
I checked that DBD::Sybase documentation and did not
find a way to get the number of rows affected by the
Is there an equivalent for ct_res_info()? Or is select
@@rowcount the only way to do it?
ct_res_info() (in C) will only return the number of rows returned by a
SELECT after all the rows have been fetched.
Same with SELECT @@rowcount (for obvious reasons - it's a bit hard to
run SELECT @@rowcount *before* the SELECT data... :-)
So DBD::Sybase's $sth->rows implementation will return valid data for
SELECT statements right after the last row has been fetched.
$sth->rows will return correct data immediately after execute() for