search for: ldproviders

I am having a problem getting the following logic to work, in a macro. Basically, if the caller ID matches, set the outbond trunk to a Zap channel, otherwise use a SIP provider. exten => s,n,Set(TRUNK=${IF($[${CALLERIDNUM} = 1234567890]?Zap/g1:SIP/LDPROVIDER)}) ; use PRI instead of SIP That works. The TRUNK variable is set properly. But the SIP LD provider requires a prepended

...I have looked at the MySQL command, and there are a lot of notes about connection closing and other scary stuff? Does it work? Are there other native options given the fact that realtime is configured and in use? The goal is to run a query against a database like this SELECT provideralias FROM ldproviders WHERE npa = (digits 2 thru 4 of dialed number) AND nxx = (digits 5 thru 7) Then take the provider alias returned and Dial(SIP/${EXTEN}@${provideralias},60). Next step would be to add a loop for multiple providers, starting with the lowest cost. Any hints or comments from the pros? TIA Damon