Tuesday, August 20, 2013, 5:47:24 PM, Gareth wrote:
> On 20/08/13 14:53, Jonas Kellens wrote:
>> Hello,
>>
>> how can I obtain the "inserted ID" after having inserted a row with
>> MySQL in the dialplan ?
>>
>> exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO myTable SET
>> C1="${ARG1}", C2="${ARG2}",
>> timestamp="${STRFTIME(${EPOCH},,%Y-%m-%d_%H:%M:%S)}")
>>
>> I need to know the ID of the newly inserted row.
> You could write an AGI script in something like php or perl and get it
> to write to the mysql database instead. It can then set a variable which
> the dialplan can pick up.
meh...
SELECT LAST_INSERT_ID()
--
Best regards,
Gergo mailto:[email protected]
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
