[Asterisk-Users] Nested MySQL Commands

Douglas Garstang dgarstang at oneeighty.com
Thu Jan 12 08:05:43 MST 2006


Andreas.

I tried that. Still didn't work. It just appears that Asterisk doesn't like letting you execute another query while it's holding on to the state of a previous one.

Doug.

-----Original Message-----
From: Andreas Sikkema [mailto:andreas.sikkema at bbned.nl]
Sent: Thursday, January 12, 2006 2:01 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: RE: [Asterisk-Users] Nested MySQL Commands


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



More information about the asterisk-users mailing list