Re: [asterisk-users] func odbc and mult iquery
2010/3/10 Tilghman Lesher tles...@digium.com
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
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Hi,
I'm using 1.6.0.20 asterisk and also I use multirow. I'm getting data like
this:
for (x=0; ${x} ${ODBCROWS}; x=${x} + 1) {
SET(ARRAY(variable,value)=${ODBC_FETCH(${RESULT})});
SET(${variable}=${value});
};
But using this, I can only retrieve first table. How to detect and retrieve
the second table?
Thanks
--
Best Regards,
Giedrius
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func odbc and mult iquery
On Friday 12 March 2010 05:55:33 voipas wrote:
2010/3/10 Tilghman Lesher tles...@digium.com
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.
I'm using 1.6.0.20 asterisk and also I use multirow. I'm getting data
like this:
for (x=0; ${x} ${ODBCROWS}; x=${x} + 1) {
SET(ARRAY(variable,value)=${ODBC_FETCH(${RESULT})});
SET(${variable}=${value});
};
But using this, I can only retrieve first table. How to detect and retrieve
the second table?
I haven't the faintest idea how returning two resultsets from a stored
procedure could possibly work, let alone how to retrieve it properly.
--
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com www.asterisk.org
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func odbc and mult iquery
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 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
