Re: How to get number of rows updated in by an sql statement? (Win32::ODBC)

The documentation for DBI is pretty good on this front.

It looks like:

$rows = $sth->rows;
[download]

... would return what you're looking for (unless the ODBC driver doesn't support this kind of method).

If the driver is very limited (I haven't worked with the Win32::ODBC driver) then you might have to fudge it a bit and try a clever SELECT statement based on the UPDATE if you really need to know how many rows were affected.

Comment on Re: How to get number of rows updated in by an sql statement? (Win32::ODBC) Download Code

Replies are listed 'Best First'.
Re: Answer: How can I get # of rows updated in a query when I use Win32::ODBC? by 2501 (Pilgrim) on Jan 15, 2001 at 09:36 UTC
that wasn't quite it. You can ignore me because I was suffering from a severe case of 24 hour blindness:P Your answer pointed me in the right direction (In the same documentation I thought I had looked through completely enough) none the less, I appreciate you took the time to answer my question despite my inadequate research:) All those here for the roshambo, please line up to the right....	[reply]