All pastes #904081 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-02-14 18:23 UTC
rendered paste body
extensions.conf:
================
exten => 414,1,Set(CALLERID(all)=JON\'W <3149>)
exten => 414,n,Set(CALLERID(all)=${PGSQL_REGEXP_REPLACE(${CALLERID(all)},\',,)})
exten => 414,n,NoOp(${CALLERID(all)})

CLI:
================
    -- Executing [414@experimental:1] Set("OSS/dsp", "CALLERID(all)=JON'W <3149>") in new stack
[Feb 14 13:18:28] WARNING[19593]: res_odbc.c:103 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42601: Error while executing the query;
ERROR:  syntax error at or near "W" at character 28 (84)


func_odbc.so:
================
; regexp_replace(source,pattern,replacement[,flags])
[REGEXP_REPLACE]
dsn=asterisk
read=SELECT regexp_replace('${ARG1}','${ARG2}','${ARG3}','${ARG4}')
prefix=PGSQL