8 Apr
2014
8 Apr
'14
3:45 a.m.
On Saturday 05 April 2014 17:32:18 Alex Balashov wrote:
When using sql_xquery() like this:
sql_xquery("ca", "SELECT * FROM gateways", "gateways");... what's a good way to check if any rows were returned? Since one does not have a $dbr(gateways=>rows) value in this scenario, what should one do?
All sqlops query functions have (undocumented) 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
It might be useful to extend $sqlrows() to return the number of rows in the resultset.
--
Alex Hermann