[asterisk-users] error cant write to function ODBC_DEVICES

[Israel Gottlieb]

Hi all

asterisk 1.8.23

I have odbc all setup to mysql but cant figure out why the dialplan wont
write to the odbc function

fubc_odbc.conf

[DEVICES]
dsn=device-conn                ;dsn in res_odbc not odbc.ini
readsql=SELECT call.callNum, call.city, devices.callId, devices.id FROM
call INNER JOIN devices ON call.id = devices.callId WHERE deviceNumber = '${
SQL_ESC(${ARG1})}'

writesql=insert into voted (callId,callNum,city,deviceId,SerialNum,
serverResponse) values (${VAL1},"${VAL2}",${VAL3},${VAL4},${VAL5},"${VAL6}"


extension.conf

the relevant line


same => n,set(ODBC_DEVICES()=${callid},${call},1,${deviceid},${num},${
serverupdate})


when sending the values from the cli using odbc write it works ok
reading from the dialplan  works ok
i tried sending plain values without variables

but from the dialplan gives me a error " cant write to function ODBC
_DEVICES"

happy to hear any ideas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20131020/345bb494/attachment.html>