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 that AEL native syntax can't be used with ODBC_FETCH. Perhaps
this helps someone in the future.
On 15. 08. 2021. 16:06, Nikša Baldun wrote:
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 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 the current one.
Best regards.
Have you tried QUOTE()?
--
Dennis Buteyn
Xorcom Ltd
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-dev mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-dev
