Re: [asterisk-users] Re: Best way to access MySQL data from dial plan

2006-12-18 Thread Andrea Spadaccini
Ciao kjcsb, 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\

RE: [asterisk-users] Re: Best way to access MySQL data from dial plan

2006-12-18 Thread Douglas Garstang
: 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

Re: [asterisk-users] Re: Best way to access MySQL data from dial plan

2006-12-18 Thread kjcsb
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! Thanks What is a better way to do it

Re: [asterisk-users] RE: Best way to access MySQL data from dial plan

2006-12-18 Thread kjcsb
Setup extconfig to have realtime access to the database/table you want to pull info from, then in the dialplan use the app Realtime. Thanks. I didn't know that you could use RealTime in the dialplan like that. I thought is was just for sip, extensions etc. I created a wiki page at