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
_______________________________________________
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
