asterisk users - May 2010 - Records sets and ODBC

Hi, I have a system using ODBC and connecting to a MS-SQL database.
Does anyone know if it is possible to return a record set consisting of
several rows from SQL back into Asterisk?  I have tried using ARRAY but
only the contents of the last row are being stored.

Thanks

Lee  
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100510/ffca36e8/attachment.htm

On Monday 10 May 2010 07:19:34 Lee Archer wrote:
> Hi, I have a system using ODBC and connecting to a MS-SQL database.
> Does anyone know if it is possible to return a record set consisting of
> several rows from SQL back into Asterisk?  I have tried using ARRAY but
> only the contents of the last row are being stored.
Only in 1.6.x (mode=multirow).

-- 
Tilghman

Thanks, I figured it out.  I was using 1.4 but have had to move to 1.6.1

Regards

Lee

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Tilghman
Lesher
Sent: 10 May 2010 17:27
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Records sets and ODBC

On Monday 10 May 2010 07:19:34 Lee Archer wrote:
> Hi, I have a system using ODBC and connecting to a MS-SQL database.
> Does anyone know if it is possible to return a record set consisting
of
> several rows from SQL back into Asterisk?  I have tried using ARRAY
but
> only the contents of the last row are being stored.
Only in 1.6.x (mode=multirow).

-- 
Tilghman

-- 
_____________________________________________________________________
-- 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