AW: [asterisk-dev] ADDON: Realtime extension

[René Enskat [Teamware GmbH]]

I get results with my changed syntax there is a error to
Coz for like there must be in oracle after that a ESCAPE '\' but my
problem is there should be a result.
When i execute my syntax inside sqlmanager i get a line but the addon
seems ti ignore it. OR? 





-----Ursprüngliche Nachricht-----
Von: asterisk-dev-bounces at lists.digium.com
[mailto:asterisk-dev-bounces at lists.digium.com] Im Auftrag von North
Antara
Gesendet: Donnerstag, 11. Mai 2006 10:06
An: Asterisk Developers Mailing List
Betreff: Re: [asterisk-dev] ADDON: Realtime extension

René Enskat [Teamware GmbH] wrote:
>
>  
> i have realtime running over oracle database when i have some _ 
> extensions in the database the asterisk won't accept them.
> Here i tried to call number 47.
> the extension for this one in the db is: _4[6-9] so the second select 
> should found something with sqlnavigator i find the row but asterisk 
> seems to stop continuing after that i get th emessage invalid 
> extension.
>  
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Retrieve SQL: SELECT * FROM ast_extension WHERE exten = '47'  AND 
> context = '10001'  AND priority = '1'
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Reconnected successfully.
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Retrieve SQL: SELECT * FROM ast_extension WHERE exten LIKE '\_%' 
> ESCAPE '\' AND context = '10001'  AND priority = '1'  ORDER BY exten 
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime:
> Reconnected successfully.
I noticed something similar with mssql.  I believe I had to change the
\\_% to _% in the code.
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-dev mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-dev