Asterisk odbc: no entries on insert

oldschool
Joined: Tue 03 of Feb, 2009

Asterisk odbc: no entries on insert

Posted:Tue 03 of Feb, 2009 (16:33 UTC)
Hi All!

I am accessing a MySql database from asterisk via odbc.

I can successfully read out data from the database via following dialplan command:
exten => s,n,Set(TEST=${ODBC_TEST_SELECT()})

snippet of /etc/asterisk/func_odbc.conf:
TEST_INSERT ( the square brackets are escaped by this site :( )
dsn=asterisk
readsql=select id from test

The problem is at excuting an insert via dialplan. It throws no error, but no entries are inserted at db. Even the odbc.log has no entries of the sql-statement.
snippet of dialplan:
exten => s,n,SayNumber(ODBC_TEST_INSERT())

snipped from func_odbc:
TEST_INSERT ( the square brackets are escaped by this site :( )
dsn=asterisk
write=insert into test values(1)



Is it possible that the method SayNumber(ODBC_TEST_INSERT()) only says the number but does nothing else?
I have the syntax from this manual page 23: http://www.astricon.net/2008/glendale/web/presentations/DatabaseDriven_JSmith.pdf

Does anyone has an advice?