have you tried with MYSQL command? <a href="http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL">http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL</a><div><br clear="all">Nasir Iqbal<br><br>ICT Innovations<br><a href="http://www.ictinnovations.com/" target="_blank">http://www.ictinnovations.com/</a><br>
<br>
<br><br><div class="gmail_quote">On Tue, Oct 4, 2011 at 11:25 PM, Bryant Zimmerman <span dir="ltr"><<a href="mailto:BryantZ@zktech.com">BryantZ@zktech.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<span style="font-family:Arial, Helvetica, sans-serif;font-size:10pt">Hey all<br>
<br>
I wanted to get some input on what you all think is the best way to lookup database data from asterisk dial plan. <br>
This is a two fold question. <br>
<br>
1. I am using fun_odbc to pull settings and values back and it works good but is there a better way. I want to maintain performance and simplicity as much as possible. <br>
<br>
2. func_odbc does not appear to allow for reading multiple records in a return set. Is there a way around this or is there a better method. <br>
<br>
I understand I can always us a mono, pearl, php, lua or some other kind of script to handel some of this but I am looking for better ways to do database access using the built-in dialplan abilities first. <br>
<br>
I look forward to ideas and input. <br>
<br>
<div>Thanks<br><font color="#888888">
Bryant</font></div></span>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>