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