search for: statusa

Hello, I'm working with asterisk 1.6. And I have success using func_odbc with one row query results (SELECT source,destination from cc WHERE ... ): exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1}, ${STATUSAS}) But I don't know how to retrieve data, if query returns a lot of rows. In documentation I read that need to use in config file: mode=multirow, and use function ODBC_FETCH. Bu...

...t; s,n,Set(HASH(RESULTATAS)=${ODBC_GETNUMBER(${NUMERIS})}) exten => s,n,Verbose(1, Number is ${HASH(RESULTATAS, number)}.) exten => s,n,Verbose(1, Realus 1 ${HASH(RESULTATAS, real_number1)}.) exten => s,n,Verbose(1, Realus 2 ${HASH(RESULTATAS, real_number2)}.) exten => s,n,Verbose(1, Statusas ${HASH(RESULTATAS, status)}.) And asterisk output is: == Using SIP RTP CoS mark 5 -- Executing [555 at from-trunk:1] Goto("SIP/sip.call.lt-01993050", "odbc-test,s,1") in new stack -- Goto (odbc-test,s,1) -- Executing [s at odbc-test:1] Ringing("SIP/sip.call....