adodb.connection execute

[Xand3r]

How can i return the number of rows affected from the example below

$con = ObjCreate("ADODB.Connection")
$con.ConnectionString="DRIVER={MySQL ODBC 5.1 Driver};SERVER=127.0.0.1;DATABASE=somedb;UID=root;PWD=somepass;PORT=3306"
$query=$con.execute("update some_table set somecolumn=someval where condition");

[Xand3r]

it seems that $con.execute("query",$Rows,1) shoud return the number of rows affected.. but it dosen't seem to be working :-S

[ResNullius]

it seems that $con.execute("query",$Rows,1) shoud return the number of rows affected.. but it dosen't seem to be working :-S

Are you initializing $Rows before your query?

$Rows = 0
$con.execute("query",$Rows,1)

The records affected value is passed by reference.

[Xand3r]

of course i am ... and it's never changes no mather how many rows the query affects

[ResNullius]

of course i am ... and it's never changes no mather how many rows the query affects

According to this page http://dev.mysql.com/doc/refman/5.0/en/con...es-apptips.html,

with a MySQL connection you should set/select the "Return matching rows" option.

That option is also known as FLAG_FOUND_ROWS and has a value of 2,

( http://dev.mysql.com/doc/refman/5.0/en/con...parameters.html )

I haven't worked with a MySQL ODBC connection myself, but I hope that helps.