On 20/08/13 17:48, Gergo Csibra wrote:
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
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.
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
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)})
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},
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
On 20/8/13 5:00 pm, A J Stiles wrote:
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?
+1. It would also give you somewhere to perform sanity checks on your
${ARGS} to avoid SQL injection
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 ?