Re: [asterisk-dev] ODBC and commas

2021-08-16 Thread Nikša Baldun
OK, false alarm (sort of). I am using AEL, which apparently always wraps the right side of assignment in $[], which messes things up. This doesn't work with commas in db field: HASH(result)="${ODBC_FETCH(${odbc_id})}"; but this does: Set(HASH(result)=${ODBC_FETCH(${odbc_id})}); It seems

Re: [asterisk-dev] ODBC and commas

2021-08-15 Thread Nikša Baldun
Tried QUOTE() where? I don't see where it can be applied. On 15. 08. 2021. 09:29, Dennis Buteyn wrote: On 8/13/21 9:51 AM, Nikša Baldun wrote: Hello, does anyone know, what is the recommended way to handle commas with func_odbc? There is a parameter “escapecommas” in func_odbc.conf, but

[asterisk-dev] ODBC and commas

2021-08-13 Thread Nikša Baldun
Hello, does anyone know, what is the recommended way to handle commas with func_odbc? There is a parameter “escapecommas” in func_odbc.conf, but regardless of its value, having a comma in DB field breaks ODBC_FETCH function. The text after the comma is assigned to the next field instead of