[asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN

Doug Lytle support at drdos.info
Mon Apr 9 20:26:26 CDT 2012


lists65 at gmail.com wrote:
> exten =>  s,n,MYSQL(Query resultid ${connid} INSERT INTO `calleridcapture`
> (`number`,`name`) VALUES (${CALLERID(num)},${CALLERID(name)})


Here is an example of one of my inserts:

exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO Indianapolis set 
phone="${CALLERID(number)}" \, flag="YES" \, note="Blacklisted by 
Tele-Torture - ${TODAY}")

Doug



More information about the asterisk-users mailing list