v5:reference:reference_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:reference:reference_index [2016/01/17 04:11] – ↷ Links adapted because of a move operation mnewnham | v5:reference:reference_index [2023/06/04 12:39] (current) – Add anchor link to ADODB_vers dregad | ||
---|---|---|---|
Line 6: | Line 6: | ||
See the [[v5: | See the [[v5: | ||
===== Variables ===== | ===== Variables ===== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
+ | | [[v5: | ||
+ | | [[v5: | ||
===== Constants ===== | ===== Constants ===== | ||
|[[v5: | |[[v5: | ||
+ | |[[v5: | ||
===== The Database Connection Object ===== | ===== The Database Connection Object ===== | ||
==== Establishing Connections ==== | ==== Establishing Connections ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
+ | **See Also** [[v5: | ||
==== Working With Cached Recordsets ==== | ==== Working With Cached Recordsets ==== | ||
ADOdb supports the ability to work with cached query results, either through storing the results on local disks, or via the use of a [[http:// | ADOdb supports the ability to work with cached query results, either through storing the results on local disks, or via the use of a [[http:// | ||
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
==== Executing SQL ==== | ==== Executing SQL ==== | ||
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
- | |[[v5: | + | | [[v5: |
==== Prepared Statements ==== | ==== Prepared Statements ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
+ | | [[v5: | ||
==== Generating Database Independent SQL strings ==== | ==== Generating Database Independent SQL strings ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
| [[v5: | | [[v5: | ||
- | | [[v5: | ||
- | | [[v5: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | |
- | | [[v5: | + | |
==== Handling Blobs ==== | ==== Handling Blobs ==== | ||
Line 93: | Line 94: | ||
| [[v5: | | [[v5: | ||
==== Paging/ | ==== Paging/ | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
| [[v5: | | [[v5: | ||
==== Transaction Scoping ==== | ==== Transaction Scoping ==== | ||
Line 111: | Line 112: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
==== Fetching Data ==== | ==== Fetching Data ==== | ||
|[[v5: | |[[v5: | ||
Line 116: | Line 119: | ||
- | ==== Dates ==== | + | ==== Manipulating |
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
Line 122: | Line 125: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
- | | [[v5: | + | | [[v5: |
+ | | [[v5: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
Line 145: | Line 149: | ||
| [[v5: | | [[v5: | ||
+ | ==== Information ==== | ||
+ | |||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | |||
- | ====== The Recordset Object | + | ===== The Recordset Object ===== |
==== Returns one field ==== | ==== Returns one field ==== | ||
|[[v5: | |[[v5: | ||
Line 153: | Line 162: | ||
This series of functions is designed to duplicate the commands and emulate the functionality provided by the now deprecated [[https:// | This series of functions is designed to duplicate the commands and emulate the functionality provided by the now deprecated [[https:// | ||
- | | [[v5: | + | | [[v5: |
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
Line 159: | Line 168: | ||
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
==== Returns all rows ==== | ==== Returns all rows ==== | ||
|[[v5: | |[[v5: | ||
|[[v5: | |[[v5: | ||
- | |[[v5: | + | |[[v5: |
|[[v5: | |[[v5: | ||
==== Scrolling ==== | ==== Scrolling ==== | ||
| [[v5: | | [[v5: | ||
- | | [[v5: | + | | [[v5: |
| [[v5: | | [[v5: | ||
- | | [[v5: | + | | [[v5: |
| [[v5: | | [[v5: | ||
| [[v5: | | [[v5: | ||
Line 179: | Line 188: | ||
==== Menu generation ==== | ==== Menu generation ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
==== Dates ==== | ==== Dates ==== | ||
Line 191: | Line 200: | ||
==== Recordset Info ==== | ==== Recordset Info ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
==== Field Info ==== | ==== Field Info ==== | ||
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
- | | [[v5: | + | | [[v5: |
==== Recordset Cleanup ==== | ==== Recordset Cleanup ==== | ||
|[[v5: | |[[v5: |
v5/reference/reference_index.txt · Last modified: 2023/06/04 12:39 by dregad