I'm not sure that any solution with the MySQL dialplan command is going to be ideal. You also can't nest your queries, ie the connectid/result id seems to only be good for one resultset at a time... try doing something like findme/followme with that!
Doug. > -----Original Message----- > From: kjcsb [mailto:[EMAIL PROTECTED] > Sent: Monday, December 18, 2006 11:33 AM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: [asterisk-users] Re: Best way to access MySQL data from dial > plan > > > Resending as message didn't show up the first time > > >I need to access MySQL from the dial plan. Currently I am > using the MYSQL > >function: > > exten => *78,n,MYSQL(Connect asterisklocal localhost > asteriskuser password > > asterisk) > > exten => *78,n,MYSQL(Query resultid ${asterisklocal} CALL\ > > sp_ins_into_avp(\'/DND/${CALLERID(number)}\'\,\'YES\')) > > exten => *78,n,MYSQL(Clear ${resultid}) > > exten => *78,n,MYSQL(Disconnect ${asterisklocal}) > > > > This shows authentication details in the Asterisk CLI which > is not ideal. > > What is the recommended way to access MySQL data? > > > > Asterisk 1.2 > > CentOS 4.4 > > MySQL 5.0 > > > > Regards > > > > Cameron > > _______________________________________________ > --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 > _______________________________________________ --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