<br><br>
<div class="gmail_quote">2010/3/10 Tilghman Lesher <span dir="ltr"><<a href="mailto:tlesher@digium.com">tlesher@digium.com</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">On Wednesday 10 March 2010 02:09:54 voipas wrote:<br>> Does asterisk func odbc support multi query? I'm executing stored<br>> procedure which returns two tables. With tsql command I can see both<br>
> tables. But asterisk only shows the first.<br>> My database is MSSQL.<br><br></div>Yes, but only in 1.6.0 and above. You'll need to set mode=multirow in<br>func_odbc.conf, and the behavior of func_odbc changes dramatically. See<br>
the sample func_odbc.conf for more information.<br><br>--<br>Tilghman Lesher<br>Digium, Inc. | Senior Software Developer<br>twitter: Corydon76 | IRC: Corydon76-dig (Freenode)<br>Check us out at: <a href="http://www.digium.com/" target="_blank">www.digium.com</a> & <a href="http://www.asterisk.org/" target="_blank">www.asterisk.org</a><br>
<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>
<div><br><br clear="all">Hi,</div>
<div> </div>
<div> I'm using 1.6.0.20 asterisk and also I use multirow. I'm getting data like this:</div>
<div> for (x=0; ${x} < ${ODBCROWS}; x=${x} + 1) {<br> SET(ARRAY(variable,value)=${ODBC_FETCH(${RESULT})});<br> SET(${variable}=${value});<br> };</div>
<div> </div>
<div>But using this, I can only retrieve first table. How to detect and retrieve the second table?</div>
<div> </div>
<div>Thanks<br>-- <br>Best Regards,<br>Giedrius<br></div>