Patch attached for sqlops_admin.xml.
Does the readme also need patching or is it generated from this xml?
--
Fred Posner
The Palner Group, Inc.
503-914-0999 (direct)
954-472-2896 (fax)
*** sqlops_admin.xml 2014-03-06 10:40:16.000000000 -0500
--- sqlops_admin_20140408.xml 2014-04-08 11:31:03.675012462 -0400
***************
*** 178,183 ****
--- 178,203 ----
</section>
<section>
<title>Functions</title>
+ <para>
+ All sqlops query functions have return values:
+ </para>
+ <itemizedlist>
+ <listitem>
+ <para>
+ <emphasis>-1</emphasis> - error in parameters or query execution
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <emphasis>1</emphasis> - query successful, at least one row in resultset (for SELECTs)
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <emphasis>2</emphasis> - query successful, no rows returned
+ </para>
+ </listitem>
+ </itemizedlist>
<section>
<title>
<function moreinfo="none">sql_query(connection, query[, result])</function>
***************
*** 262,267 ****
--- 282,290 ----
sql_xquery("ca", "select * from domain", "ra");
xlog("first domain: $xavp(ra=>domain) with id: $xavp(ra=>domain_id)\n");
...
+ if (sql_xquery("ca", "select * from domain", "ra") == 1)
+ { xlog("domain: $xavp(ra=>domain) with id: $xavp(ra=>domain_id)\n"); }
+ ..
</programlisting>
</example>
</section>
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
