<p>George Joseph <strong>submitted</strong> this change.</p><p><a href="https://gerrit.asterisk.org/c/asterisk/+/13968">View Change</a></p><div style="white-space:pre-wrap">Approvals:
Joshua Colp: Looks good to me, but someone else must approve
George Joseph: Looks good to me, approved; Approved for Submit
</div><pre style="font-family: monospace,monospace; white-space: pre-wrap;">func_odbc.conf.sample: Clarify sample documentation<br><br>ASTERISK-20325 #close<br><br>Change-Id: I06cb9b467b0fd06c8af2a5aee049f872c09cc4b6<br>---<br>M configs/samples/func_odbc.conf.sample<br>1 file changed, 7 insertions(+), 4 deletions(-)<br><br></pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;"><span>diff --git a/configs/samples/func_odbc.conf.sample b/configs/samples/func_odbc.conf.sample</span><br><span>index 706b9ce..c467f7e 100644</span><br><span>--- a/configs/samples/func_odbc.conf.sample</span><br><span>+++ b/configs/samples/func_odbc.conf.sample</span><br><span>@@ -35,14 +35,15 @@</span><br><span> ;</span><br><span> ; The following options are available in this configuration file:</span><br><span> ;</span><br><span style="color: hsl(120, 100%, 40%);">+; dsn An alias for "writehandle."</span><br><span> ; readhandle A comma-separated list of DSNs (from res_odbc.conf) to use when</span><br><span> ; executing the readsql statement. Each DSN is tried, in</span><br><span> ; succession, until the statement succeeds. You may specify up to</span><br><span> ; 5 DSNs per function class. If not specified, it will default to</span><br><span style="color: hsl(0, 100%, 40%);">-; the value of writehandle or dsn, if specified.</span><br><span style="color: hsl(120, 100%, 40%);">+; the value of "writehandle" or "dsn," if specified.</span><br><span> ; writehandle A comma-separated list of DSNs (from res_odbc.conf) to use when</span><br><span> ; executing the writesql statement. The same rules apply as to</span><br><span style="color: hsl(0, 100%, 40%);">-; readhandle. "dsn" is a synonym for "writehandle".</span><br><span style="color: hsl(120, 100%, 40%);">+; readhandle.</span><br><span> ; readsql The statement to execute when reading from the function class.</span><br><span> ; writesql The statement to execute when writing to the function class.</span><br><span> ; insertsql The statement to execute when writing to the function class</span><br><span>@@ -60,6 +61,8 @@</span><br><span> ; off is incompatible with the functionality of HASH().</span><br><span> ; synopsis Appears in the synopsis field for the command</span><br><span> ; 'core show function <function name>'</span><br><span style="color: hsl(120, 100%, 40%);">+; syntax Appears in the syntax field for the command</span><br><span style="color: hsl(120, 100%, 40%);">+; 'core show function <function name>'</span><br><span> ; mode This option may be set to 'multirow' to allow the function</span><br><span> ; specified to return more than a single row. However, this</span><br><span> ; changes the way that func_odbc normally works. Instead of the</span><br><span>@@ -88,7 +91,7 @@</span><br><span> </span><br><span> ; ODBC_SQL - Allow an SQL statement to be built entirely in the dialplan</span><br><span> [SQL]</span><br><span style="color: hsl(0, 100%, 40%);">-dsn=mysql1</span><br><span style="color: hsl(120, 100%, 40%);">+writehandle=mysql1</span><br><span> readsql=${ARG1}</span><br><span> </span><br><span> ; ODBC_ANTISOLICIT - A blacklist for known solicitors.</span><br><span>@@ -104,6 +107,6 @@</span><br><span> </span><br><span> ; ODBC_PRESENCE - Retrieve and update presence</span><br><span> [PRESENCE]</span><br><span style="color: hsl(0, 100%, 40%);">-dsn=mysql1</span><br><span style="color: hsl(120, 100%, 40%);">+writehandle=mysql1</span><br><span> readsql=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}'</span><br><span> writesql=UPDATE presence SET location='${SQL_ESC(${VAL1})}' WHERE id='${SQL_ESC(${ARG1})}'</span><br><span></span><br></pre><p>To view, visit <a href="https://gerrit.asterisk.org/c/asterisk/+/13968">change 13968</a>. To unsubscribe, or for help writing mail filters, visit <a href="https://gerrit.asterisk.org/settings">settings</a>.</p><div itemscope itemtype="http://schema.org/EmailMessage"><div itemscope itemprop="action" itemtype="http://schema.org/ViewAction"><link itemprop="url" href="https://gerrit.asterisk.org/c/asterisk/+/13968"/><meta itemprop="name" content="View Change"/></div></div>
<div style="display:none"> Gerrit-Project: asterisk </div>
<div style="display:none"> Gerrit-Branch: 17 </div>
<div style="display:none"> Gerrit-Change-Id: I06cb9b467b0fd06c8af2a5aee049f872c09cc4b6 </div>
<div style="display:none"> Gerrit-Change-Number: 13968 </div>
<div style="display:none"> Gerrit-PatchSet: 2 </div>
<div style="display:none"> Gerrit-Owner: Sean Bright <sean.bright@gmail.com> </div>
<div style="display:none"> Gerrit-Reviewer: Friendly Automation </div>
<div style="display:none"> Gerrit-Reviewer: George Joseph <gjoseph@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: Joshua Colp <jcolp@sangoma.com> </div>
<div style="display:none"> Gerrit-MessageType: merged </div>