[Asterisk-Users] How to query a table from the keypad?

[Chris A. Icide]

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:* asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] *On Behalf Of
> *Richard Reina
> *Sent:* Friday, 24 February 2006 9:34 AM
> *To:* asterisk-users at lists.digium.com
> *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=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http:/autos.yahoo.com/newcars/popular/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
>