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