[asterisk-users] func odbc and mult iquery

[Tilghman Lesher]

On Wednesday 10 March 2010 02:09:54 voipas wrote:
>   Does asterisk func odbc support multi query? I'm executing stored
> procedure which returns two tables. With tsql command I can see both
> tables. But asterisk only shows the first.
> My database is MSSQL.

Yes, but only in 1.6.0 and above.  You'll need to set mode=multirow in
func_odbc.conf, and the behavior of func_odbc changes dramatically.  See
the sample func_odbc.conf for more information.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org