<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 20/08/13 14:53, Jonas Kellens wrote:
<blockquote cite="mid:521374D2.2090000@telenet.be" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
how can I obtain the "inserted ID" after having inserted a row
with MySQL in the dialplan ?<br>
<br>
exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO
myTable SET C1="${ARG1}", C2="${ARG2}",
timestamp="${STRFTIME(${EPOCH},,%Y-%m-%d_%H:%M:%S)}")<br>
<br>
I need to know the ID of the newly inserted row.</font><br>
</blockquote>
<br>
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.<br>
<br>
</body>
</html>