ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:selectlimit

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
v5:reference:connection:selectlimit [2016/01/17 00:30] – ↷ Page moved from v5:reference:selectlimit to v5:reference:connection:selectlimit mnewnhamv5:reference:connection:selectlimit [2016/03/20 02:32] – [Description] mnewnham
Line 17: Line 17:
 The function executes a statement, and returns a handle to a recordset or false if the statement execution fails. 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 [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[v5:reference:connection:setfetchmode|setFetchMode()]].+The presentation of the returned data can be modified by the variables:   
 +  * [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] 
 +  [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]]  
 +  * The function [[v5:reference:connection:setfetchmode|setFetchMode()]].
  
-For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:execute|execute()]].+For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:connection:execute|execute()]].
  
 ===== $rowsToReturn ===== ===== $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 are returned. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[v5: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 =====
v5/reference/connection/selectlimit.txt · Last modified: 2023/07/25 12:55 by dregad