v5:reference:connection:adodb_recordset
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
v5:reference:connection:adodb_recordset [2016/02/26 03:06] – created mnewnham | v5:reference:connection:adodb_recordset [2016/02/28 03:33] (current) – mnewnham | ||
---|---|---|---|
Line 145: | Line 145: | ||
^Field^Description| | ^Field^Description| | ||
|databaseType] => array | |databaseType] => array | ||
- | |_array|Array | + | |_array|An array that holds all the retrieved records| |
- | ( | + | |
- | [0] => Array | + | |
- | ( | + | |
- | [Order ID] => 30 | + | |
- | [Employee ID] => 9 | + | |
- | [Customer ID] => 27 | + | |
- | [Order Date] => 2006-01-15 00:00:00 | + | |
- | [Shipped Date] => 2006-01-22 00:00:00 | + | |
- | [Shipper ID] => 2 | + | |
- | [Ship Name] => Karen Toh | + | |
- | [Ship Address] => 789 27th Street | + | |
- | [Ship City] => Las Vegas | + | |
- | [Ship State/ | + | |
- | [Ship ZIP/Postal Code] => 99999 | + | |
- | [Ship Country/ | + | |
- | [Shipping Fee] => 200.0000 | + | |
- | [Taxes] => .0000 | + | |
- | [Payment Type] => Check | + | |
- | [Paid Date] => 2006-01-15 00:00:00 | + | |
- | [Notes] => | + | |
- | [Tax Rate] => 0.0 | + | |
- | [Tax Status] => | + | |
- | [Status ID] => 3 | + | |
- | ) | + | |
- | + | ||
- | [1] => Array | + | |
- | ( | + | |
- | [Order ID] => 31 | + | |
- | [Employee ID] => 3 | + | |
- | [Customer ID] => 4 | + | |
- | [Order Date] => 2006-01-20 00:00:00 | + | |
- | [Shipped Date] => 2006-01-22 00:00:00 | + | |
- | [Shipper ID] => 1 | + | |
- | [Ship Name] => Christina Lee | + | |
- | [Ship Address] => 123 4th Street | + | |
- | [Ship City] => New York | + | |
- | [Ship State/ | + | |
- | [Ship ZIP/Postal Code] => 99999 | + | |
- | [Ship Country/ | + | |
- | [Shipping Fee] => 5.0000 | + | |
- | [Taxes] => .0000 | + | |
- | [Payment Type] => Credit Card | + | |
- | [Paid Date] => 2006-01-20 00:00:00 | + | |
- | [Notes] => | + | |
- | [Tax Rate] => 0.0 | + | |
- | [Tax Status] => | + | |
- | [Status ID] => 3 | + | |
- | ) | + | |
- | + | ||
- | + | ||
- | ) | + | |
|_types|| | |_types|| | ||
|_colnames|| | |_colnames|| | ||
|_skiprow1|| | |_skiprow1|| | ||
- | |_fieldobjects|Array | + | |_fieldobjects|An array of [[v5: |
- | ( | + | |
- | [0] => ADOFieldObject Object | + | |
- | ( | + | |
- | [name] => Order ID | + | |
- | [max_length] => 10 | + | |
- | [type] => COUNTER | + | |
- | ) | + | |
- | + | ||
- | [1] => ADOFieldObject Object | + | |
- | ( | + | |
- | [name] => Employee ID | + | |
- | [max_length] => 10 | + | |
- | [type] => INTEGER | + | |
- | ) | + | |
- | + | ||
- | ) | + | |
|canSeek|| | |canSeek|| | ||
- | |affectedrows|| | + | |affectedrows|If the the statement executed is not a select, the number of rows affected by the statement. This value is database dependant and is accessible via the [[v5: |
|insertid|| | |insertid|| | ||
- | |sql|SELECT * FROM orders| | + | |sql|The SQL statement issued to produce the result| |
|compat|| | |compat|| | ||
|dataProvider|odbc| | |dataProvider|odbc| | ||
- | |fields|Array | + | |fields|The list of column names returned by the query, if appropriate| |
- | ( | + | |
- | [Order ID] => 30 | + | |
- | [Employee ID] => 9 | + | |
- | [Customer ID] => 27 | + | |
- | [Order Date] => 2006-01-15 00:00:00 | + | |
- | [Shipped Date] => 2006-01-22 00:00:00 | + | |
- | [Shipper ID] => 2 | + | |
- | [Ship Name] => Karen Toh | + | |
- | [Ship Address] => 789 27th Street | + | |
- | [Ship City] => Las Vegas | + | |
- | [Ship State/ | + | |
- | [Ship ZIP/Postal Code] => 99999 | + | |
- | [Ship Country/ | + | |
- | [Shipping Fee] => 200.0000 | + | |
- | [Taxes] => .0000 | + | |
- | [Payment Type] => Check | + | |
- | [Paid Date] => 2006-01-15 00:00:00 | + | |
- | [Notes] => | + | |
- | [Tax Rate] => 0.0 | + | |
- | [Tax Status] => | + | |
- | [Status ID] => 3 | + | |
- | ) | + | |
- | | | + | |
|blobSize|| | |blobSize|| | ||
- | |EOF|| | + | |EOF|A boolean value indicating if EOF has been reached. This value can be queried using ADOConnection:: |
|emptyTimeStamp|| | |emptyTimeStamp|| | ||
|emptyDate|| | |emptyDate|| | ||
- | |debug|| | + | |debug|Indicates whether [[v5: |
|timeCreated|| | |timeCreated|| | ||
|bind|| | |bind|| | ||
|fetchMode|The Fetch mode in use when the query was executed|[[v5: | |fetchMode|The Fetch mode in use when the query was executed|[[v5: | ||
|connection|This is a recursive link to the ADOconnection Object| | |connection|This is a recursive link to the ADOconnection Object| | ||
- | |_numOfRows|The number of rows returned from a query|[[v5: | + | |_numOfRows|The number of rows returned from a query, if appropriate, |
|_numOfFields|The number of columns returned by the query|| | |_numOfFields|The number of columns returned by the query|| | ||
|_queryID|The PHP resource in use when the query was executed| | |_queryID|The PHP resource in use when the query was executed| | ||
- | |_currentRow|| | + | |_currentRow|The current row number when iterating through the the recordset, see [[v5: |
|_closed|| | |_closed|| | ||
|_inited|| | |_inited|| | ||
Line 272: | Line 180: | ||
|_maxRecordCount|| | |_maxRecordCount|| | ||
|datetime|| | |datetime|| | ||
- | |||
- | |
v5/reference/connection/adodb_recordset.txt · Last modified: 2016/02/28 03:33 by mnewnham