On Tuesday 20 August 2013, 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.
>
>
>
> Kind regards,
> Jonas.
I'm not sure it's possible to do that using the simple MySQL interface
provided within the dialplan.
Why not write an AGI script in your favourite language (Perl, Python, PHP,
Java all have AGI and MySQL bindings) to perform the INSERT query for you?
You can supply values for C1 and C2 easily enough; and have your AGI script
return the insert ID in a channel variable. (You could also return another
channel variable indicating success or failure, if this is important.)
--
AJS
Answers come *after* questions.
--
_____________________________________________________________________
-- 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
