[asterisk-users] MYSQL INSERT QUESTION IN DIALPLAN

[lists65 at gmail.com]

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