You can do any form of SQL statements in a lua script. Checkout how to create a dbh connection. William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com On 07/04/2014 10:53 PM, Normando Hall wrote:
Hello.
I am working on an IVR based on FS. This is what I want to do:
I have a huge database with a few fields: 'phone number' - 'address street' - 'address number' - 'address building' - 'address floor' - etc.
When I receive a call I will query the CallerID into de 'phone number' field. If found it, the phrase macro says something like "Hello, your address is xxxx, xxx" If the caller confirm pressing 1, then we will use this query results to activate other systems in the server, such as storing or trigger an event. I was recorder each street name and numers with an annoucer (broadcaster) into a separate wav files.
I was reading about *mod_cidlookup*, but I don't know if this is the better way to achieve this. Another way I see are related to*mod_db*, *mod_dptools*, *mod_easyroute*, etc.
Thanks for your advices.
Normando Hall
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org