Differences

This shows you the differences between two versions of the page.

--- reference:selectlimit [2015/07/21 19:19] – [selectLimit] mnewnham
+++ v5:reference:connection:selectlimit [2019/05/08 16:40] – ADODB_ASSOC_CASE not $ADODB_ASSOC_CASE dregad
@@ Line 17: / Line 17: @@
 The function executes a statement, and returns a handle to a recordset or false if the statement execution fails.
-The presentation of the returned data can be modified by the variables [[reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[reference:setfetchmode|setFetchMode()]].
+The presentation of the returned data can be modified by:
+  * [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] variable,
+  * [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant,
+  * [[v5:reference:connection:setfetchmode|setFetchMode()]] function.
-For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[reference:execute|execute()]].
+For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:connection:execute|execute()]].
 ===== $rowsToReturn =====
-''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned my be less. If the value is -1, then all rows starting at the requested offset. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[reference:execute|execute()]].
+''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned my be less. If the value is -1, then all rows starting at the requested offset are returned. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[v5:reference:connection:execute|execute()]].
+===== $startOffset =====
+''$startOffset'' indicates the n<sup>th</sup> row at which to start the request. Row numbers start at 0.  If the row number is beyond End-Of-File then an empty recordset will be returned.
@@ Line 31: / Line 37: @@
  * DB2 Connection assumed
 */
-$ar = $db->getAll("SELECT * FROM ACT");
+$SQL = "SELECT * FROM act";
+$result = $db->selectLimit($SQL,2,3);
+while ($r = $result->fetchRow())
+    print_r($r);
 /*
- * $ar returns:
+ * Returns 2 rows starting at offset 3 (4th record starting at 0)
 Array
 (
-    [0] => Array
+    [0] => 40
-        (
+    [1] => LEADPR
-            [0] => 10
+    [2] => LEAD PROGRAM/DESIGN
-            [1] => MANAGE
+)
-            [2] => MANAGE/ADVISE
+Array
-        )
+(
+    [0] => 50
-    [1] => Array
+    [1] => SPECS
-        (
+    [2] => WRITE SPECS
-            [0] => 20
+)
-            [1] => ECOST
-            [2] => ESTIMATE COST
-        )
-    [2] => Array
-        (
-            [0] => 30
-            [1] => DEFINE
-            [2] => DEFINE SPECS
-.......
 */
 </code>