[asterisk-users] func_odbc do not read LIKE predicate

[Vadim Lungu]

Hello everyone,
I would be extremely glad if someone could help me with the following issue:
cat /etc/asterisk/func_odbc.conf
[call_user]
prefix=GET
dsn=asterisk_odbc_sip
readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477'

Asterisk CLI show the following issue:
     -- Executing [205 at phones_wildcard:1] 
NoOp("SIP/Y_MD_vlungu_477-00000008", 
"000000000000000000000000000000000000000000000000000") in new stack
     -- Executing [205 at phones_wildcard:2] 
NoOp("SIP/Y_MD_vlungu_477-00000008", "205") in new stack
        > Found no rows [SELECT name FROM asterisk_sippeers WHERE name = 
'%477']
     -- Executing [205 at phones_wildcard:3] 
Set("SIP/Y_MD_vlungu_477-00000008", "YUID=") in new stack
     -- Executing [205 at phones_wildcard:4] 
NoOp("SIP/Y_MD_vlungu_477-00000008", 
"##################################################") in new stack
     -- Executing [205 at phones_wildcard:5] 
NoOp("SIP/Y_MD_vlungu_477-00000008", 
"##################################################") in new stack
     -- Executing [205 at phones_wildcard:6] 
Macro("SIP/Y_MD_vlungu_477-00000008", "simple,,30") in new stack

Anyone has any ideas what is going wrong ?

-- 
Mit freundlichen Grüßen / Best regards

Vadim Lungu
*System Engineer*

Tel 	+49-941-569592-0
Fax 	+49-941-569592-99
Mail 	vadim.lungu at yopeso.com <mailto:vadim.lungu at yopeso.com>
Web 	https://www.yopeso.com

	
*YOPESO s.r.l.*
Calea Orheiului 20/1
2059 Chisinau
Republik Moldau
Registergericht Chisinau
Registernummer 1008600037623 	VAT-ID 0207159
Geschäftsführer Svetlana Arnaut

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140313/da819d87/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_yopeso_signature_small.jpg
Type: image/jpeg
Size: 3520 bytes
Desc: not available
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140313/da819d87/attachment.jpg>