[Asterisk-Users] Can I introduce sql sentences in the DialPlan (Asterisk Realtime)??

[Leonardo F. Bauchwitz]

Matthew Boehm wrote:

> Leonardo F. Bauchwitz wrote:
>
>> Hallo all!
>>
>> Know somebody, if exist Dialplan commands (specifically sql sentences)
>> for Asterisk Realtime?
>>
>> For example:
>> I have users defined in mysql database.
>> In the dialplan, I would like to select one field of a table.
>> select email from sip_buddies where name=200
>>
>> I try to use DBget, but I have error. I think because DBget use intern
>> Database, and can 't connect to mysql.
>> (Sintaxis:  DBget(varname=family/key))
>>
>> I think (if it does not exist at the moment) that it is very interesant
>> we can write in the dialplan sql-sentences
>> What think about this?
>>
>> Leonardo F. Bauchwitz
>
>
> CLI> show application realtime
>
> you could do
>
> exten => 12,1,Realtime(sippeers,name,200)
>
> also look at app_addon_mysql if you want to do pure SQL queries not 
> supported by realtime
>
> -Matthew
>
Thanks Matthew!
That is the answer to my question..
Realtime is wonderful

Regards

Leonardo F. Bauchwitz

	

	
		
___________________________________________________________ 
1GB gratis, Antivirus y Antispam 
Correo Yahoo!, el mejor correo web del mundo 
http://correo.yahoo.com.ar