How do I get insert id after using R::exec

[Ramadhan Amizudin]

Hi, for the odd reason I had to use R::exec function to insert new data.
The problem is, how do I get insert id after doing R::exec?

Thanks.

[gabor]

R::$adapter->getInsertID()

or in 4.2 beta 3:

R::getInsertID()

cheers
Gabor

[Will Blackamoor]

Hi Gabor, rather than open a new thread i thought i would rather ask here. Is there a method for getting the affected rows from an Atomic/Conditional Update Query. Since its conditional i had to Use exec, but i haven't been able to find any information about it so far on google.

[gabor]

Hi,

R::exec will return the number of affected rows.

R::setup();
R::store(R::dispense('bean')->setAttr('xname','beanie'));
$x = R::exec('UPDATE bean SET xname = 1234 WHERE id < 2');
var_dump($x);

Outputs: 1

cheers
Gabor