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.
--
_____________________________________________________________________
-- 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
