Hello,
Now I'm testing func_odbc and hash. My configurations are:
func_odbc.conf
[GETNUMBER]
dsn=sqlserver
;mode=multirow
;rowlimit=10
readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers
WHERE number=${SQL_ESC(${ARG1})}
extensions.conf
exten => s,1,Ringing
exten => s,n,Wait(4)
exten => s,n,Answer
exten => s,n,Set(NUMERIS=37037210602)
exten => 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 [EMAIL PROTECTED]:1] Goto("SIP/sip.call.lt-01993050",
"odbc-test,s,1") in new stack
-- Goto (odbc-test,s,1)
-- Executing [EMAIL PROTECTED]:1] Ringing("SIP/sip.call.lt-01993050", "") in
new stack
-- Executing [EMAIL PROTECTED]:2] Wait("SIP/sip.call.lt-01993050", "4") in
new stack
-- Executing [EMAIL PROTECTED]:3] Answer("SIP/sip.call.lt-01993050", "") in
new stack
-- Executing [EMAIL PROTECTED]:4] Set("SIP/sip.call.lt-01993050",
"NUMERIS=111") in new stack
-- Executing [EMAIL PROTECTED]:5] Set("SIP/sip.call.lt-01993050",
"HASH(RESULTATAS)=111,222,333,2") in new stack
-- Executing [EMAIL PROTECTED]:6] Verbose("SIP/sip.call.lt-01993050", "1,
Number is .") in new stack
Number is .
-- Executing [EMAIL PROTECTED]:7] Verbose("SIP/sip.call.lt-01993050", "1,
Realus 1 .") in new stack
Realus 1 .
-- Executing [EMAIL PROTECTED]:8] Verbose("SIP/sip.call.lt-01993050", "1,
Realus 2 .") in new stack
Realus 2 .
-- Executing [EMAIL PROTECTED]:9] Verbose("SIP/sip.call.lt-01993050", "1,
Statusas .") in new stack
Statusas .
-- Auto fallthrough, channel 'SIP/sip.call.lt-01993050' status is
'UNKNOWN'
As I read documentation, function hash gives posibility to get values using
column name. But my test was unsuccessful. Maybe somebody can help...
Thanks
--
Pagarbiai / Best Regards,
Giedrius Augys
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
