Release Notes: New caching functions were added: CacheGetOne, CacheGetRow, CacheGetAll. A new function for scheduling appointments portably was added. $conn->OffsetDate($dayFraction,$date=false) can be used to generate SQL that calculates date offsets. Portability when handling joins was improved. The "leftOuter" and "rightOuter" connection properties were added for left and right outer join operators, and "ansiOuter" was added to indicate that ANSI outer joins are supported. The "mssqlpo" portable MSSQL driver was added. This allows you to write portable SQL, using "||" for string concatenation, and have it automatically converted to "+" when you switch to MSSQL.
Release Notes: Support was added for converting recordsets to text formats such as CSV and tab-delimited. PageExecute() and CachePageExecut() SQL rewriting problems were fixed. Extracting Interbase field names is now more accurate.
Release Notes: This release has $db->Replace() to perform an update or insert if the record is not found, and a data pager class that generates HTML to display data in a nice table with a navigation bar for scrolling. The session handler has been optimized by using crc32 on the data and updating only when the session variables change. The ADO driver now uses client cursors. Quote() now checks for magic quotes automatically.
Release Notes: In this version, emulated RecordCount() is now stable. There is improved blob support, RowLock() now supported in most databases, and there is support for PHP 4.2.0 ODBC API changes. The CommitTrans($ok) function now allows the setting of the $ok parameter to false to rollback. There are new OCI805, Informix72 and Postgres64 drivers, and new sysDate and sysTimeStamp properties for portable date and timestamp creation. There are also miscellaneous bugfixes.
Release Notes: RecordCount() now works in all databases that previously did not support it. The bind parameter API was unified for oci8 and mssql stored procedures. Informix SELECT FIRST support and Interbase Prepare/Execute support were added. UnixTimeStamp() and UnixDate() were added to ADOConnection(). Miscellaneous fixes and speedups were made.
Release Notes: Untested $ADODB_FETCH_MODE support has been added to ifx, Sybase, and Frontbase. Oci8 now supports binding variables. There is better error handling, and Sybase SQL Anywhere support for blobs. MSSQL and ODBC support GenID() properly.
Release Notes: This release fixes some backward compatibility problems introduced in 1.80. It also has improved Oracle hint optimization in SelectLimit( ).
Release Notes: A new directory structure is now used. All the test scripts have been moved to adodb/tests, and database-specific code is now in adodb/drivers. A new Sybase SQL Anywhere driver (using ODBC) was developed. The Informix and mssql drivers were improved. Lastly, the recordset caching algorithm should scale better now.
Release Notes: In this release, a new beta Informix driver was added, it still requires metadata and ISO date support. Some miscellaneous bugs were fixed.
Release Notes: Cross-database date support is the main improvement in this release. DBDate() and DBTimeStamp() now correctly convert UNIX timestamps, ISO dates, and nulls into database-specific date strings. Gen_ID($seqname,$startid) now allows you to create sequences that start from a specific value.