Can't get ODBC writesql to work

Asterisk Asterisk Support
1

Hello everybody,

I’m having trouble getting the ODBC writesql function to work. ODBC itself is working fine, since I am using readsql quite a few times in my dialplan, so I assume it’s just a wrong notation or something, but I just can’t figure it out.

In my func_odbc.conf I define the query like this:

[INSERTWAV]
dsn=asterisk
writsql=INSERT INTO wavfiles (pin, filename) VALUES ('${SQL_ESC(${VAL1})}', '${SQL_ESC(${VAL2})}')

And in my dialplan I’m using the following syntax:

same => n,Set(ODBC_INSERTWAV()=${EXTEN},${STRFTIME(${EPOCH},,%d.%m.%Y-%H:%M)})

I would be very thankful for some help here!

Greetings,
Eggat

2

I think you may have forgotten the ‘e’ in writesql