Com obj. ADODB connection.

[jokke]

Hiya!

Working with a mysql odbc object, where wondering if anyone know how i should get recaffected (last row affected) when i have done a execution.

As of now i use a simple workaround:

ID = rownum
Insertion -->"INSERT INTO `TableX` (id,userid) VALUES (NULL,'jokke');"
Retrieve <---"SELECT `id` FROM `TableX` WHERE `userid` LIKE 'jokke' ORDER BY `id` DESC LIMIT 0 , 1;"

Iwe used this site as a referance: http://www.w3schools.com/ADO/ev_conn_execute.asp for the object properties.

Edited August 15, 2008 by jokke

[PsaltyDS]

Hiya!

Working with a mysql odbc object, where wondering if anyone know how i should get recaffected (last row affected) when i have done a execution.

As of now i use a simple workaround:

ID = rownum
Insertion -->"INSERT INTO `TableX` (id,userid) VALUES (NULL,'jokke');"
Retrieve <---"SELECT `id` FROM `TableX` WHERE `userid` LIKE 'jokke' ORDER BY `id` DESC LIMIT 0 , 1;"

Iwe used this site as a referance: http://www.w3schools.com/ADO/ev_conn_execute.asp for the object properties.

That appears to be a parameter passed by an event, not a property you can read. Look in the help file under OBJ/COM Reference, in the section titled "COM Events", and also at the ObjEvent() function.

It would look something like:

$oAdoDbEvent = ObjEvent($oAdoDb, "_AdoDbEvent_")

; ...perform $oAdoDb.Execute()

Func _AdoDbEvent_ExecuteComplete($recaffected, $objerror, $status, $objcomm, $objrs, $objconn)
    MsgBox(64, "ADODB Event", "Execute Complete: recaffected = " & $recaffected)
EndFunc

...or similar.