v5:reference:connection:selectlimit
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
reference:selectlimit [2015/07/21 19:19] – [selectLimit] mnewnham | v5: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 [[reference: | + | The presentation of the returned data can be modified by the variables: |
+ | * [[v5:reference: | ||
+ | * [[v5:reference: | ||
+ | * The function [[v5:reference:connection: | ||
- | For a detailed description of the '' | + | For a detailed description of the '' |
===== $rowsToReturn ===== | ===== $rowsToReturn ===== | ||
- | '' | + | '' |
+ | |||
+ | ===== $startOffset ===== | ||
+ | '' | ||
Line 31: | Line 37: | ||
* DB2 Connection assumed | * DB2 Connection assumed | ||
*/ | */ | ||
- | $ar = $db-> | + | $SQL = " |
+ | $result = $db-> | ||
+ | while ($r = $result-> | ||
+ | print_r($r); | ||
/* | /* | ||
- | | + | |
+ | |||
Array | Array | ||
( | ( | ||
- | [0] => Array | + | [0] => 40 |
- | ( | + | [1] => LEADPR |
- | [0] => 10 | + | [2] => LEAD PROGRAM/DESIGN |
- | | + | ) |
- | [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 | + | |
- | ....... | ||
*/ | */ | ||
| | ||
</ | </ | ||
v5/reference/connection/selectlimit.txt · Last modified: 2023/07/25 12:55 by dregad