[asterisk-users] FUNC_ODBC and ARRAY

[Sherwood McGowan]

Gentlemen,

I have googled, searched the mailing list archives, and even spoke on
the IRC channel, but have not found an answer to the following
problem. I am attempting to retrieve multiple columns in an ODBC query
using ARRAY per the solutions offered by many individuals. My dialplan
code is as follows:

exten => _.,n,Set(ARRAY(var1,var2,var3)=${ODBC_LOOKUP(${KEYVAL})})
exten => _.,n,Verbose(2,var1 = ${var1})
exten => _.,n,Verbose(2,var2 = ${var2})
exten => _.,n,Verbose(2,var3 =  ${var3})

Here's the func_odbc.conf code:

[LOOKUP]
dsn=mysql-asterisk
readsql=SELECT col1, col2, col3 from table1 WHERE keycol = '${ARG1}'

and here's the full log:
[Jan 22 20:12:50] VERBOSE[32348] pbx.c:     -- Executing
[123 at dolookup:8] Set("SIP/sip1-inbound-00000f99",
"ARRAY(var1,var2,var3)=96829,-3,Name Unavailabl") in new stack
[Jan 22 20:12:50] DEBUG[32348] func_strings.c: array (var1,var2,var3=96829)
[Jan 22 20:12:50] DEBUG[32348] func_strings.c: array set value (var1=96829)
[Jan 22 20:12:50] DEBUG[32348] func_strings.c: array set value (var2=(null))
[Jan 22 20:12:50] DEBUG[32348] func_strings.c: array set value (var3=(null))
[Jan 22 20:12:50] WARNING[32348] pbx.c: MSet: ignoring entry '-3' with
no '=' (in +17322761300 at getcnam:8

Asterisk version: 1.6.2.14
MySQL: 5.1.37

Thoughts?