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
--
_____________________________________________________________________
-- 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
