how to get # of affected rows from update query

Hi all. How can I get the number of rows affected by an update query? I'm using PostgreSQL.

I use ADOdb for all my db work, and I've tried the Affected_Rows property of the connection object, but it doesn't seem to work.

Here's the code I'm executing:

$file = $conn->Execute("BEGIN; update cms_content set content = 'foo' where cms_id = 2; COMMIT");

echo $conn->Affected_Rows();

and while the update is successful, the number of affected rows shows up as 0.

Anyone have any ideas what's causing this?

Also, is there a way I can find out from the transaction if it completed successfully or not?

Thanks in advance,
P.

Jemand?