[asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN

[Noah Engelberth]

>-----Original Message-----
>From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of lists65 at gmail.com
>Sent: Monday, April 09, 2012 8:34 PM
>To: asterisk-users at lists.digium.com
>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
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: AVG Certification.txt
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120410/0c971aea/attachment.txt>