[asterisk-users] MySQL/IVR Integration

[Julian Lyndon-Smith]

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