[asterisk-users] Multiple Return Values from func_odbc

[Tilghman Lesher]

On Wednesday 28 November 2007 16:55:14 Douglas Garstang wrote:
> Thanks... That was just what I needed.
> But.... what about going the other way? How can I pass multiple values to a
> function in func_odbc? I can't use ARRAY as it can only be used to set
> variables, not read form them!

func_odbc.conf:
read=SELECT ${ARG3} FROM tablename WHERE ${ARG1}='${ARG2}'
write=UPDATE tablename SET ${ARG3}='${VAL1}' WHERE ${ARG1}='${ARG2}'

extensions.conf:

Set(foo=${ODBC_WHATEVER(field1,blah,field17)})
Set(ODBC_WHATEVER(field1,blah,field36)=bar)

Multiple values are tricky in 1.4 due to Set syntax, but we've solved that
in the upcoming 1.6 by simplifying the dialplan syntax.

-- 
Tilghman