-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Noah Engelberth Sent: Monday, April 09, 2012 9:52 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN
>-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] >Sent: Monday, April 09, 2012 8:34 PM >To: [email protected] >Subject: [asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN >I am not a programmer and I have learned so much from examples and the list. >Perhaps someone could tell me what I am doing wrong in my example below: >I am getting the caller ID and caller name from my local POTS line and I want to add it into a sql table. I am trying with the following code but the data never gets put into the table. >Can anyone correct my syntax and tell me what I am doing wrong? >[callerinfo] >exten => s,1,MYSQL(Connect connid localhost myuser mypassword cnam) exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO `calleridcapture` >(`number`,`name`) VALUES (${CALLERID(num)},${CALLERID(name)}) >exten => s,n,MYSQL(Clear ${resultid}) >exten => s,n,MYSQL(Disconnect ${connid}) exten => s,n,NoOp(Callerid Name ${CALLERID(name)}) exten => s,n,NoOp(Callerid Number ${CALLERID(num)}) >The NoOP does show the correct CALLERID name & number when I test it. The information just doesn't go into my calleridcapture table in the cnam database. >Thanks very much for your help >Again I am not a programmer and I am sure my syntax is wrong. >This is Asterisk 1.8.10.0 > As the previous two posters alluded, you need to encapsulate your values in quotes. I think you can get by without the backticks, not 100% sure as I've converted from MYSQL to func_odbc. If you're not going to go with Steve's recommendation of AGI, I would highly recommend switching from func_mysql to func_odbc; func_odbc is much more straightforward in my opinion, and you definitely get much better error messages within the CLI as you're watching your code execute. ofps.oreilly.com/titles/9780596517342/asterisk-DB.html is a good resource for setting up odbc. Noah Thanks for your responses. Well, the AGI piece sounds good, but again I am not a programmer but I certainly will try and try to find some code that I could piece together and try to make it work. I will check out Oreilly's stuff, they always seem to have good books when you are trying to learn something new. Thanks again, I really appreciate your resonse. -- _____________________________________________________________________ -- 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
