[asterisk-users] MySQL/IVR Integration

[Jon Schøpzinsky]

Func_odbc is actually also backported to 1.2, so its your friend there too.

Regards
Jon

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Julian Lyndon-Smith
Sent: 21. maj 2007 08:59
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] MySQL/IVR Integration

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

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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: 20-05-2007 07:54
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: 20-05-2007 07:54