[asterisk-users] Dialplan MySQL inserted ID

[Gergo Csibra]

Tuesday, August 20, 2013, 6:08:19 PM, Jonas wrote:

> On 08/20/2013 06:03 PM, Gergo Csibra wrote:
>> 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()
>>

> Hello,

> can I echo this variable ?

Like : exten =>> s,n,NoOp(${LAST_INSERT_ID()})

No, this is a mysql query, so:

exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO myTable SET C1="${ARG1}", C2="${ARG2}", timestamp="${STRFTIME(${EPOCH},,%Y-%m-%d_%H:%M:%S)}")
exten => s,n,MYSQL(Query resultid ${connid} SELECT LAST_INSERT_ID())
exten =>> s,n,NoOp(${resultid})

first is your original insert query, next you must read the
last_insert_id() mysql function with an other query, then you can
echo the resultid variable which contains the last inserted id.



-- 
Best regards,
 Gergo                            mailto:csibra at gmail.com