What kind of overhead do agi put on? Are they that much worst than running mysql addon functions?
|-----Original Message----- |From: [EMAIL PROTECTED] |[mailto:[EMAIL PROTECTED] On Behalf Of |Chris A. Icide |Sent: Sunday, February 26, 2006 12:23 PM |To: Asterisk Users Mailing List - Non-Commercial Discussion |Subject: Re: [Asterisk-Users] How to query a table from the keypad? | |Or you could skip the overhead associated with an AGI and use |the dialplan command availabe after installing asterisk-addons MYSQL. | |exten => _X.,1,Read(PO-NUMBER,enter-yr-po-num) |exten => _X.,2,MYSQL(Connect connid <dbhost> <dbuser> <dbpass> |<dbname>) exten => _X.,3,MYSQL(Query resultid ${connid} SELECT |balance FROM account-payables WHERE po_num=${PO-NUMBER}) exten |=> _X.,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE) exten => |_X.,5,MYSQL(Clear ${resultid}) | |Of course you will want to put in place all the error traps |and when using this function I always have a check in my |hangup routine to make sure I close the open mysql connection. |So at the end of the above dialplan, you should have the value |you want in the AMOUNT-DUE variable. | |-Chris | |Mike Pollitt wrote: |> |> Hi Richard - |> |> What you want is AGI: |> http://www.voip-info.org/tiki-index.php?page=Asterisk+AGI |> |> You could write a perl script to read the PO number from stdin and |> spit back the balance (or whatever). To read the PO number from the |> user, use the Read() dialplan application. To play back the balance, |> you could use SayDigits() (but there's probably a more elegant |> solution specifically for speaking amounts of money). |> |> |---------------------------------------------------------------------- |> -- |> |> *From:* [EMAIL PROTECTED] |> [mailto:[EMAIL PROTECTED] *On Behalf Of |> *Richard Reina |> *Sent:* Friday, 24 February 2006 9:34 AM |> *To:* [email protected] |> *Subject:* [Asterisk-Users] How to query a table from the keypad? |> |> I am trying to give users the option to query our accts. payable |> database by supplying their PO number. I able to write queries via |> perl->DBI->mysql but have no idea how to get * to do it from the IVR. |> Is this possible? Can anyone point me in the right direction |for help |> or examples? |> |> Thanks, |> |> Richard |> |> |---------------------------------------------------------------------- |> -- |> |> |> What are the most popular cars? Find out at Yahoo! Autos |> |<http://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc |> |2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http:/autos.yahoo.com/newcars/popul |> ar/thisweek.html%20%0d%0a> |> |> |> |---------------------------------------------------------------------- |> -- |> |> _______________________________________________ |> --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 |> | | |_______________________________________________ |--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 | | _______________________________________________ --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
