I have all my SIP users in a realtime database. I would like to use MySQL command to query the database and use the results from the query to page all the phones found in the query.
The results from the MySQL query will be multiple rows of extension: Something like: mysql> Select extension from sip where extension like '6%' 6001 6002 6003 ex.... I need to put all the results into a variable that would equal something like: SIP/6001&SIP/6002&SIP/6003 I have setup a couple basic MYSQL Query's for my dialplan. Mostly just looking up a DID to Extension Mapping for setting callerid on outbound and inbound calls. How does asterisk handle the multiple results. Is there a way to loop until there are no more rows? Something like Set(devices=${devices}&${newrow_result}) I looked at the example on http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL but that doesn't seem to be accurate. Thanks all!! -- *** Forrest Beck IAXTEL: 17002871718 [EMAIL PROTECTED] _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users