asterisk users - Dec 2006 - Re: Best way to access MySQL data from dial plan

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:kjcsb@orcon.net.nz]
> 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
>