Func_odbc is actually also backported to 1.2, so its your friend there too.
Regards Jon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 _______________________________________________ --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
