>-----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
The message does not contain any threats
AVG for MS Exchange Server (2012.0.1913 - 2411/4924)
--
_____________________________________________________________________
-- 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
