[asterisk-users] Dialplan MySQL inserted ID

[Jonas Kellens]

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()})


Kind regards,

Jonas.