search for: odbc_lookup

...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'...