Displaying 3 results from an estimated 3 matches for "writehandl".
Did you mean:
writehandle
2008 Dec 09
2
Func_ODBC question
Hi I have
On func_odbc
[EXEC]
readhandle=ressqlserver
writehandle=ressqlserver
readsql=${ARG1}
writesql=${ARG1}
I'm trying an update on dialplan:
exten=> 141,3,Set(dummy=${ODBC_EXEC(UPDATE Tabla set campo = ${EXTEN})})
On Cli:
WARNING[3579]: func_odbc.c:353 acf_odbc_read: Error -1 in FETCH [UPDATE
Tabla set campo = 4356]
Any idea...
2008 Jul 10
1
res_odbc.conf and odbc show
...0 12:07:04 DEBUG[30281] pbx.c: Function result is 'voip2'
Jul 10 12:07:04 DEBUG[30281] pbx.c: Function result is 'CF/4053'
Jul 10 12:07:04 ERROR[30281] func_odbc.c: Unable to load ODBC write class (check
res_odbc.conf)
func_odbc.conf:
[ASTDB_CLUSTER]
; readhandle=astdb_cluster
; writehandle=astdb_cluster
dsn=astdb_cluster
readsql=SELECT value FROM astdb_cluster WHERE field='${SQL_ESC(${ARG1})}' and host='${SQL_ESC(${ARG2})}'
writesql=INSERT INTO astdb_cluster (host,field,value) VALUES ('${SQL_ESC(${ARG1})}','${SQL_ESC(${ARG2})}',${VALUE})
res_odbc.co...
2014 May 29
1
voicemail with odbc
...blacklist.
[ANTIGF]
dsn=mysql1,mysql2 ; Use mysql1 as the primary handle, but fall back to
mysql2
; if mysql1 is down. Supports up to 5 comma-separated
; DSNs. "dsn" may also be specified as "readhandle" and
; "writehandle", 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_PRE...