[asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN

[Doug Lytle]

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