Re: MYSQL INSERT QUESTION IN DIALPLAN

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



lists65@xxxxxxxxx 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

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


[Gnu Gatekeeper]     [IETF Sipping]     [Info Cyrus]     [ALSA User]     [Fedora Linux Users]     [DCCP]     [Gimp]     [100% Free Online Dating]     [Yosemite News]     [Arts & Crafts]     [Yosemite Photos]     [Deep Creek Hot Springs]     [Yosemite Campsites]     [ISDN Cause Codes]


Add to Google Powered by Linux