*** 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 ----
Functions + + All sqlops query functions have return values: + + + + + -1 - error in parameters or query execution + + + + + 1 - query successful, at least one row in resultset (for SELECTs) + + + + + 2 - query successful, no rows returned + + +
<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>