Displaying 1 result from an estimated 1 matches for "dbdefaulthost".
2011 May 17
1
mysql call stored procedure
...lling the procedure from mysql cli it gives a result like:
mysql> call call_control(78236721,1000,1233);
+------+
| pass |
+------+
| 1 |
+------+
So I need asterisk to recognize this pass and take some actions based on
what the pass value is.
Dialplan looks like this:
MYSQL(Connect connid ${DBDefaultHost} ${DBuser} ${DBpass} ${DBname})
MySQL(Query resultid ${connid} CALL call_control(78236721,1000,1233))
MySQL(Fetch fetchid ${resultid} pass)
MYSQL(clear ${resultid})
MySQL(Query resultid ${connid} SELECT/INSERT whatever from table)
So, it gives me this pass value correct, but if I execute some othe...