Displaying 2 results from an estimated 2 matches for "odbc_presence".
2013 Oct 20
1
error cant write to function ODBC_DEVICES
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})}'
2014 May 29
1
voicemail with odbc
...itehandle", if it is important to separate reads
and
; writes to different databases.
readsql=SELECT COUNT(*) FROM exgirlfriends WHERE
callerid='${SQL_ESC(${ARG1})}'
syntax=<callerid>
synopsis=Check if a specified callerid is contained in the ex-gf database
; ODBC_PRESENCE - Retrieve and update presence
[PRESENCE]
dsn=mysql1
readsql=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}'
writesql=UPDATE presence SET location='${SQL_ESC(${VAL1})}' WHERE
id='${SQL_ESC(${ARG1})}'
*voicemail show command*
abox*CLI> voicemail show users
Y...