-----Original Message----- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Doug Lytle Sent: Monday, April 09, 2012 9:26 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN
list...@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 -- _____________________________________________________________________ -- 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 Thank you Doug. I did see some examples with the "\" but I was confused because I thought you didn't have to do that with 1.8 (maybe I misread that some where along the line). I will look at your example and see if I can adapt what I am doing to make it work for me. I appreciate your help and comments as well. That's what is so good about this list, seems like there is always someone that can help. I really like this stuff, I wished that I had got into programming a long time ago so I could start to understand syntax better. I missed out when I didn't pick up learning how to code. -- _____________________________________________________________________ -- 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