[Asterisk-Users] Nested MySQL Commands

[Andreas Sikkema]

> Is it possible to have nested MySQL queries in extensions.conf?
>  
> Ie, perform a query, grab a value, and then jump to another 
> location in the dialplan and do another query based on that 
> original value. I'm having problems with the result and 
> fetchid's and I'm not sure if it's even possible to do this or not.

Just make sure that you use different variable names for each 
query if the values should stay available after the next query.

What we tend to do is grab the data from the database and the stuff 
that should stay around for a longer time is assigned to a new and 
appropriately named variable. So the original variable can be used 
again.

We've got loads of queries in our extensions.conf.

-- 
Andreas Sikkema                       BBned NV
Software Engineer                Planeetbaan 4
+31 (0)23 7074342            2132 HZ Hoofddorp