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
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to