<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>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:</p>
<p>HASH(result)="${ODBC_FETCH(${odbc_id})}";</p>
<p>but this does:</p>
<p>Set(HASH(result)=${ODBC_FETCH(${odbc_id})});</p>
<p>It seems that AEL native syntax can't be used with ODBC_FETCH.
Perhaps this helps someone in the future.</p>
<div class="moz-cite-prefix">On 15. 08. 2021. 16:06, Nikša Baldun
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1a262c96-81e1-c7c1-8d94-76508dcebc88@voxdiversa.hr">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>Tried QUOTE() where? I don't see where it can be applied.<br>
</p>
<div class="moz-cite-prefix">On 15. 08. 2021. 09:29, Dennis Buteyn
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:6261299b-f208-4555-8261-21d26fdf3049@xorcom.com">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<div class="moz-cite-prefix">On 8/13/21 9:51 AM, Nikša Baldun
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:b6f22cfb-9739-55ef-c16d-c1cea6f9f39d@voxdiversa.hr">Hello,
<br>
<br>
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. <br>
<br>
Best regards. <br>
<br>
<br>
</blockquote>
<p><font face="Liberation Sans">Have you tried QUOTE()?</font><br>
</p>
<pre class="moz-signature" cols="72">--
Dennis Buteyn
Xorcom Ltd</pre>
</blockquote>
</blockquote>
</body>
</html>