asterisk users - May 2007 - MySQL/IVR Integration

Hello,

I'm looking to do the following, and I wonder if Asterisk can be used for
it, and if yes, if anyone can point me to the relevant information (commands,
sample config...):

1. Caller dials 111, 222 or 333.
2. Based on the dialed number, Asterisk queries an external MySQL table and
retrieves alphanumeric data, plays/announces it to the user and deletes the row
from the database:

The SQL queries would look something like: 
SELECT user, pwd FROM codes WHERE dialed = '111';
DELETE FROM codes WHERE user=$user AND pwd=$pwd;

Thanks,

David






       
____________________________________________________________________________________Ready
for the edge of your seat?
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/

David,

   Have a look at:

    http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

-- Alex


--
Alex Balashov   <sasha@presidium.org>

in 1.4, func_odbc is your friend.

Julian.

David wrote:
> Hello,
> 
> I'm looking to do the following, and I wonder if Asterisk can be used
for it, and if yes, if anyone can point me to the relevant information
(commands, sample config...):
> 
> 1. Caller dials 111, 222 or 333.
> 2. Based on the dialed number, Asterisk queries an external MySQL table and
retrieves alphanumeric data, plays/announces it to the user and deletes the row
from the database:
> 
> The SQL queries would look something like: 
> SELECT user, pwd FROM codes WHERE dialed = '111';
> DELETE FROM codes WHERE user=$user AND pwd=$pwd;
> 
> Thanks,
> 
> David
> 
> 
> 
> 
> 
> 
>        
>
____________________________________________________________________________________Ready
for the edge of your seat?
> Check out tonight's top picks on Yahoo! TV. 
> http://tv.yahoo.com/
> _______________________________________________
> --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
> 
> ______________________________________________________________________
> This email for dotr.com has been scanned by MessageLabs
> ______________________________________________________________________
> 
>