2.31 20 Aug 2002
Made changes to pivottable.inc.php due to daniel lucuzaeu's suggestions (we sum the pivottable column if desired).
Fixed ErrorNo() in postgres so it does not depend on _errorMsg property.
Robert Tuttle added support for oracle cursors. See ExecuteCursor().
Fixed Replace() so it works with mysql when updating record where data has not changed. Reported by Cal Evans (cal#calevans.com).
2.30 1 Aug 2002
Added pivottable.inc.php. Thanks to daniel.lucazeau#ajornet.com for the original concept.
Added ADOConnection::outp($msg,$newline) to output error and debugging messages. Now you can override this using the ADODB_OUTP constant and use your own output handler.
Changed == to === for 'null' comparison. Reported by ericquil#yahoo.com
Fixed mssql SelectLimit( ) bug when distinct used.
2.30 1 Aug 2002
New GetCol() and CacheGetCol() from ross#bnw.com that returns the first field as a 1 dim array.
We have an empty recordset, but RecordCount() could return -1. Fixed. Reported by "Jonathan Polansky" jonathan#polansky.com.
We now check for session variable changes using strlen($sessval).crc32($sessval). Formerly we only used crc32().
Informix SelectLimit() problem with $ADODB_COUNTRECS fixed.
Fixed informix SELECT FIRST x DISTINCT, and not SELECT DISTINCT FIRST x - reported by F Riosa
Now default adodb error handlers ignores error if @ used.
If you set $conn->autoRollback=true, we auto-rollback persistent connections for odbc, mysql, oci8, mssql. Default for autoRollback is false. No need to do so for postgres. As interbase requires a transaction id (what a flawed api), we don't do it for interbase.
Changed PageExecute() to use non-greedy preg_match when searching for "FROM" keyword.
2.20 9 July 2002
Added CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
Added $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs date offsets. Useful for scheduling appointments.
Added connection properties: leftOuter, rightOuter that hold left and right outer join operators.
Added connection property: ansiOuter to indicate whether ansi outer joins supported.
New driver mssqlpo, the portable mssql driver, which converts string concat operator from || to +.
Fixed ms access bug - SelectLimit() did not support ties - fixed.
Karsten Kraus (Karsten.Kraus#web.de), contributed error-handling code to ADONewConnection. Unfortunately due to backward compat problems, had to rollback most of the changes.
Added new parameter to GetAssoc() to allow returning an array of key-value pairs, ignoring any additional columns in the recordset. Off by default.
Corrected mssql $conn->sysDate to return only date using convert().
CacheExecute() improved debugging output.
Changed rs2html() so newlines are converted to BR tags. Also optimized rs2html() based on feedback by "Jerry Workman" jerry#mtncad.com.
Added support for Replace() with Interbase, using DELETE and INSERT.
Some minor optimizations (mostly removing & references when passing arrays).
Changed GenID() to allows id's larger than the size of an integer.
Added force_session property to oci8 for better updateblob() support.
Fixed PageExecute() which did not work properly with sql containing GROUP BY.
2.12 12 June 2002
Added toexport.inc.php to export recordsets in CSV and tab-delimited format.
CachePageExecute() does not work - fixed - thx John Huong.
Interbase aliases not set properly in FetchField() - fixed. Thx Stefan Goethals.
Added cache property to adodb pager class. The number of secs to cache recordsets.
SQL rewriting bug in pageexecute() due to skipping of newlines due to missing /s modifier. Fixed.
Max size of cached recordset due to a bug was 256000 bytes. Fixed.
Speedup of 1st invocation of CacheExecute() by tuning code.
We compare $rewritesql with $sql in pageexecute code in case of rewrite failure.
2.11 7 June 2002
Fixed PageExecute() rewrite sql problem - COUNT(*) and ORDER BY don't go together with mssql, access and postgres. Thx to Alexander Zhukov alex#unipack.ru
DB2 support for CHARACTER type added - thx John Huong huongch#bigfoot.com
For ado, $argProvider not properly checked. Fixed - kalimero#ngi.it
Added $conn->Replace() function for update with automatic insert if the record does not exist. Supported by all databases except interbase.
2.10 4 June 2002
Added uniqueSort property to indicate mssql ORDER BY cols must be unique.
Optimized session handler by crc32 the data. We only write if session data has changed.
adodb_sess_read in adodb-session.php now returns ''correctly - thanks to Jorma Tuomainen, webmaster#wizactive.com
Mssql driver did not throw EXECUTE errors correctly because ErrorMsg() and ErrorNo() called in wrong order. Pointed out by Alexios Fakos. Fixed.
Changed ado to use client cursors. This fixes BeginTran() problems with ado.
Added handling of timestamp type in ado.
Added to ado_mssql support for insert_id() and affected_rows().
Added support for mssql.datetimeconvert=0, available since php 4.2.0.
Made UnixDate() less strict, so that the time is ignored if present.
Changed quote() so that it checks for magic_quotes_gpc.
Changed maxblobsize for odbc to default to 64000.
2.00 13 May 2002
Added drivers informix72 for pre-7.3 versions, and oci805 for oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers are now identical.
Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode.
Proper support for blobs in mssql. Also revised blob support code is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency.
Added support for changed odbc_fetch_into api in php 4.2.0 with $conn->_has_stupid_odbc_fetch_api_change.
Fixed spelling of tablock locking hint in GenID( ) for mssql.
Added RowLock( ) to several databases, including oci8, informix, sybase, etc. Fixed where error in mssql RowLock().
Added sysDate and sysTimeStamp properties to most database drivers. These are the sql functions/constants for that database that return the current date and current timestamp, and are useful for portable inserts and updates.
Support for RecordCount() caused date handling in sybase and mssql to break. Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for both databases. Generalized using arrayClass property. Also to support RecordCount(), changed metatype handling for ado drivers. Now the type returned in FetchField is no longer a number, but the 1-char data type returned by MetaType. At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats. Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling. Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM).
Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com
Added $ok parameter to CommitTrans($ok) for easy rollbacks.
Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE.
Some odbc drivers did not call the base connection class constructor. Fixed.
Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations.
1.99 21 April 2002
Added emulated RecordCount() to all database drivers if $ADODB_COUNTRECS = true (which it is by default). Inspired by Cristiano Duarte (cunha17#uol.com.br).
Unified stored procedure support for mssql and oci8. Parameter() and PrepareSP() functions implemented.
Added support for SELECT FIRST in informix, modified hasTop property to support this.
Changed csv driver to handle updates/deletes/inserts properly (when Execute() returns true). Bind params also work now, and raiseErrorFn with csv driver. Added csv driver to QA process.
Better error checking in oci8 UpdateBlob() and UpdateBlobFile().
Added TIME type to MySQL - patch by Manfred h9125297#zechine.wu-wien.ac.at
Prepare/Execute implemented for Interbase/Firebird
Changed some regular expressions to be anchored by /^ $/ for speed.
Added UnixTimeStamp() and UnixDate() to ADOConnection(). Now these functions are in both ADOConnection and ADORecordSet classes.
Empty recordsets were not cached - fixed.
Thanks to Gaetano Giunta (g.giunta#libero.it) for the oci8 code review. We didn't agree on everything, but i hoped we agreed to disagree!
1.90 6 April 2002
Now all database drivers support fetch modes ADODB_FETCH_NUM and ADODB_FETCH_ASSOC, though still not fully tested. Eg. Frontbase, Sybase, Informix.
NextRecordSet() support for mssql. Contributed by "Sven Axelsson" sven.axelsson#bokochwebb.se
Added blob support for SQL Anywhere. Contributed by Wade Johnson wade#wadejohnson.de
Fixed some security loopholes in server.php. Server.php also supports fetch mode.
Generalized GenID() to support odbc and mssql drivers. Mssql no longer generates GUID's.
Experimental RowLock($table,$where) for mssql.
Properly implemented Prepare() in oci8 and ODBC.
Added Bind() support to oci8 to support Prepare().
Improved error handler. Catches CacheExecute() and GenID() errors now.
Now if you are running php from the command line, debugging messages do not output html formating. Not 100% complete, but getting there.
1.81 22 March 2002
Restored default $ADODB_FETCH_MODE = ADODB_FETCH_DEFAULT for backward compatibility.
SelectLimit for oci8 improved - Our FIRST_ROWS optimization now does not overwrite existing hint.
New Sybase SQL Anywhere driver. Contributed by Wade Johnson wade#wadejohnson.de
1.80 15 March 2002
Redesigned directory structure of ADOdb files. Added new driver directory where all database drivers reside.
Changed caching algorithm to create subdirectories. Now we scale better.
Informix driver now supports insert_id(). Contribution by "Andrea Pinnisi" pinnisi#sysnet.it
Added experimental ISO date and FetchField support for informix.
Fixed a quoting bug in Execute() with bind parameters, causing problems with blobs.
Mssql driver speedup by 10-15%.
Now in CacheExecute($secs2cache,$sql,...), $secs2cache is optional. If missing, it will take the value defined in $connection->cacheSecs (default is 3600 seconds). Note that CacheSelectLimit(), the secs2cache is still compulsory - sigh.
Sybase SQL Anywhere driver (using ODBC) contributed by Wade Johnson wade#wadejohnson.de
1.72 8 March 2002
Added @ when returning Fields() to prevent spurious error - "Michael William Miller" mille562#pilot.msu.edu
MetaDatabases() for postgres contributed by Phil pamelant#nerim.net
Mitchell T. Young (mitch#youngfamily.org) contributed informix driver.
Fixed rs2html() problem. I cannot reproduce, so probably a problem with pre PHP 4.1.0 versions, when supporting new ADODB_FETCH_MODEs.
Mattia Rossi (mattia#technologist.com) contributed BlobDecode() and UpdateBlobFile() for postgresql using the postgres specific pg_lo_import()/pg_lo_open() - i don't use them but hopefully others will find this useful. See this posting for an example of usage.
Added UpdateBlobFile() for uploading files to a database.
Made UpdateBlob() compatible with oci8po driver.
Added noNullStrings support to oci8 driver. Oracle changes all ' ' strings to nulls, so you need to set strings to ' ' to prevent the nullifying of strings. $conn->noNullStrings = true; will do this for you automatically. This is useful when you define a char column as NOT NULL.
Fixed UnixTimeStamp() bug - wasn't setting minutes and seconds properly. Patch from Agusti Fita i Borrell agusti#anglatecnic.com.
Toni Tunkkari added patch for sybase dates. Problem with spaces in day part of date fixed.
1.71 18 Jan 2002
Sequence start id support. Now $conn->Gen_ID('seqname', 50) to start sequence from 50.
CSV driver fix for selectlimit, from Andreas - akaiser#vocote.de.
Gam3r spotted that a global variable was undefined in the session handler.
Mssql date regex had error. Fixed - reported by Minh Hoang vb_user#yahoo.com.
DBTimeStamp() and DBDate() now accept iso dates and unix timestamps. This means that the PostgreSQL handling of dates in GetInsertSQL() and GetUpdateSQL() can be removed. Also if these functions are passed '' or null or false, we return a SQL null.
GetInsertSQL() and GetUpdateSQL() now accept a new parameter, $magicq to indicate whether quotes should be inserted based on magic quote settings - suggested by dj#4ict.com.
Reformated docs slightly based on suggestions by Chris Small.
1.65 28 Dec 2001
Fixed borland_ibase class naming bug.
Now instead of using $rs->fields internally, we use reset($rs->fields) so that we are compatible with ADODB_FETCH_ASSOC mode. Reported by Nico S.
Changed recordset constructor and _initrs() for oci8 so that it returns the field definitions even if no rows in the recordset. Reported by Rick Hickerson (rhickers#mv.mv.com).
Improved support for postgresql in GetInsertSQL and GetUpdateSQL by "mike" mike#partner2partner.com and "Ryan Bailey" rebel#windriders.com
1.64 20 Dec 2001
Danny Milosavljevic <danny.milo#gmx.net> added some patches for MySQL error handling and displaying default values.
Fixed some ADODB_FETCH_BOTH inconsistencies in odbc and interbase.
Added more tests to test suite to cover ADODB_FETCH_* and ADODB_ERROR_HANDLER.
Added firebird (ibase) driver
Added borland_ibase driver for interbase 6.5
1.63 13 Dec 2001Absolute to the adodb-lib.inc.php file not set properly. Fixed.
1.62 11 Dec 2001
Major speedup of ADOdb for low-end web sites by reducing the php code loading and compiling cycle. We conditionally compile not so common functions. Moved csv code to adodb-csvlib.inc.php to reduce adodb.inc.php parsing. This file is loaded only when the csv/proxy driver is used, or CacheExecute() is run. Also moved PageExecute(), GetSelectSQL() and GetUpdateSQL() core code to adodb-lib.inc.php. This reduced the 70K main adodb.inc.php file to 55K, and since at least 20K of the file is comments, we have reduced 50K of code in adodb.inc.php to 35K. There should be 35% reduction in memory and thus 35% speedup in compiling the php code for the main adodb.inc.php file.
Highly tuned SelectLimit() for oci8 for massive speed improvements on large files. Selecting 20 rows starting from the 20,000th row of a table is now 7 times faster. Thx to Tomas V V Cox.
Allow . and # in table definitions in GetInsertSQL and GetUpdateSQL. See ADODB_TABLE_REGEX constant. Thx to Ari Kuorikoski.
Added ADODB_PREFETCH_ROWS constant, defaulting to 10. This determines the number of records to prefetch in a SELECT statement. Only used by oci8.
Added high portability Oracle class called oci8po. This uses ? for bind variables, and lower cases column names.
Now all database drivers support $ADODB_FETCH_MODE, including interbase, ado, and odbc: ADODB_FETCH_NUM and ADODB_FETCH_ASSOC. ADODB_FETCH_BOTH is not fully implemented for all database drivers.
1.61 Nov 2001
Added PO_RecordCount() and PO_Insert_ID(). PO stands for portable. Pablo Roca [pabloroca#mvps.org]
GenID now returns 0 if not available. Safer is that you should check $conn->hasGenID for availability.
M'soft ADO we now correctly close recordset in _close() peterd#telephonetics.co.uk
MSSQL now supports GenID(). It generates a 16-byte GUID from mssql newid() function.
Changed ereg_replace to preg_replace in SelectLimit. This is a fix for mssql. Ereg doesn't support t or n! Reported by marino Carlos xaplo#postnuke-espanol.org
Added $recordset->connection. This is the ADOConnection object for the recordset. Works with cached and normal recordsets. Surprisingly, this had no affect on performance!
1.54 15 Nov 2001Fixed some more bugs in PageExecute(). I am getting sick of bug in this and will have to reconsider my QA here. The main issue is that I don't use PageExecute() and to check whether it is working requires a visual inspection of the html generated currently. It is possible to write a test script but it would be quite complicated :(
More speedups of SelectLimit() for DB2, Oci8, access, vfp, mssql.
1.53 7 Nov 2001Added support for ADODB_FETCH_ASSOC for ado and odbc drivers.
Tuned GetRowAssoc(false) in postgresql and mysql.
Stephen Van Dyke contributed ADOdb icon, accepted with some minor mods.
Enabled Affected_Rows() for postgresql
Speedup for Concat() using implode() - Benjamin Curtis ben_curtis#yahoo.com
Fixed some more bugs in PageExecute() to prevent infinite loops
1.52 5 Nov 2001Spelling error in CacheExecute() caused it to fail. $ql should be $sql in line 625!
Added fixes for parsing [ and ] in GetUpdateSQL().
1.51 5 Nov 2001
Oci8 SelectLimit() speedup by using OCIFetch().
Oci8 was mistakenly reporting errors when $db->debug = true.
If a connection failed with ODBC, it was not correctly reported - fixed.
_connectionID was inited to -1, changed to false.
Added $rs->FetchRow(), to simplify API, ala PEAR DB
Added PEAR DB compat mode, which is still faster than PEAR! See adodb-pear.inc.php.
Removed postgres pconnect debugging statement.
1.50 31 Oct 2001
ADOdbConnection renamed to ADOConnection, and ADOdbFieldObject to ADOFieldObject.
PageExecute() now checks for empty $rs correctly, and the errors in the docs on this subject have been fixed.
odbc_error() does not return 6 digit error correctly at times. Implemented workaround.
Added ADORecordSet_empty class. This will speedup INSERTS/DELETES/UPDATES because the return object created is much smaller.
Added Prepare() to odbc, and oci8 (but doesn't work properly for oci8 still).
Made pgsql a synonym for postgre7, and changed SELECT LIMIT to use OFFSET for compat with postgres 7.2.
Revised adodb-cryptsession.php thanks to Ari.
Set resources to false on _close, to force freeing of resources.
Added adodb-errorhandler.inc.php, adodb-errorpear.inc.php and raiseErrorFn on Freek's urging.
GetRowAssoc($toUpper=true): $toUpper added as default.
Errors when connecting to a database were not captured formerly. Now we do it correctly.
1.40 19 September 2001
PageExecute() to implement page scrolling added. Code and idea by Iván Oliva.
Some minor postgresql fixes.
Added sequence support using GenID() for postgresql, oci8, mysql, interbase.
Added UpdateBlob support for interbase (untested).
Added encrypted sessions (see adodb-cryptsession.php). By Ari Kuorikoski <kuoriari#finebyte.com>
1.31 21 August 2001
Many bug fixes thanks to "GaM3R (Cameron)" <gamr#outworld.cx>. Some session changes due to Gam3r.
Fixed qstr() to quote also.
rs2html() now pretty printed.
Jonathan Younger jyounger#unilab.com contributed the great idea GetUpdateSQL() and GetInsertSQL() which generates SQL to update and insert into a table from a recordset. Modify the recordset fields array, then can this function to generate the SQL (the SQL is not executed).
"Nicola Fankhauser" <nicola.fankhauser#couniq.com> found some bugs in date handling for mssql.
Added minimal Oracle support for LOBs. Still under development.Added $ADODB_FETCH_MODE so you can control whether recordsets return arrays which are numeric, associative or both. This is a global variable you set. Currently only MySQL, Oci8, Postgres drivers support this.
PostgreSQL properly closes recordsets now. Reported by several people.
Added UpdateBlob() for Oracle. A hack to make it easier to save blobs.
Oracle timestamps did not display properly. Fixed.
1.20 6 June 2001
Now Oracle can connect using tnsnames.ora or server and service name
Extensive Oci8 speed optimizations. Oci8 code revised to support variable binding, and /*+ FIRST_ROWS */ hint.
Worked around some 4.0.6 bugs in odbc_fetch_into().
Paolo S. Asioli paolo.asioli#libero.it suggested GetRowAssoc().
Escape quotes for oracle wrongly set to '. Now '' is used.
Variable binding now works in ODBC also.
Jumped to version 1.20 because I don't like 13 :-)
1.12 6 June 2001
Changed $ADODB_DIR to ADODB_DIR constant to plug a security loophole.
Changed _close() to close persistent connections also. Prevents connection leaks.
Major revision of oracle and oci8 drivers. Added OCI_RETURN_NULLS and OCI_RETURN_LOBS to OCIFetchInto(). BLOB, CLOB and VARCHAR2 recognition in MetaType() improved. MetaColumns() returns columns in correct sort order.
Interbase timestamp input format was wrong. Fixed.
1.11 20 May 2001
Improved file locking for Windows.
Probabilistic flushing of cache to avoid avalanche updates when cache timeouts.
Cached recordset timestamp not saved in some scenarios. Fixed.
1.10 19 May 2001
Added caching. CacheExecute() and CacheSelectLimit().
Added csv driver. See http://php.weblogs.com/ADODB_csv.
Fixed SelectLimit(), SELECT TOP not working under certain circumstances.
Added better Frontbase support of MetaTypes() by Frank M. Kromann.
1.01 24 April 2001
Fixed SelectLimit bug. not quoted properly.
SelectLimit: SELECT TOP -1 * FROM TABLE not support by Microsoft. Fixed.
GetMenu improved by glen.davies#cce.ac.nz to support multiple hilited items
FetchNextObject() did not work with only 1 record returned. Fixed bug reported by $tim#orotech.net
Fixed mysql field max_length problem. Fix suggested by Jim Nicholson (jnich#att.com)
1.00 16 April 2001
Given some brilliant suggestions on how to simplify ADOdb by akul. You no longer need to setup $ADODB_DIR yourself, and ADOLoadCode() is automatically called by ADONewConnection(), simplifying the startup code.
FetchNextObject() added. Suggested by Jakub Marecek. This makes FetchObject() obsolete, as this is more flexible and powerful.
Misc fixes to SelectLimit() to support Access (top must follow distinct) and Fields() in the array recordset. From Reinhard Balling.
0.96 27 Mar 2001
ADOConnection Close() did not return a value correctly. Thanks to akul#otamedia.com.
When the horrible magic_quotes is enabled, back-slash () is changed to double-backslash (\). This doesn't make sense for Microsoft/Sybase databases. We fix this in qstr().
Fixed Sybase date problem in UnixDate() thanks to Toni Tunkkari. Also fixed MSSQL problem in UnixDate() - thanks to milhouse31#hotmail.com.
MoveNext() moved to leaf classes for speed in MySQL/PostgreSQL. 10-15% speedup.
Added null handling in bindInputArray in Execute() -- Ron Baldwin suggestion.
Fixed some option tags. Thanks to john#jrmstudios.com.
0.95 13 Mar 2001
Added postgres7 database driver which supports LIMIT and other version 7 stuff in the future.
Added SelectLimit to ADOConnection to simulate PostgreSQL's "select * from table limit 10 offset 3". Added helper function GetArrayLimit() to ADORecordSet.
Fixed mysql metacolumns bug. Thanks to Freek Dijkstra (phpeverywhere#macfreek.com).
Also many PostgreSQL changes by Freek. He almost rewrote the whole PostgreSQL driver!
Added fix to input parameters in Execute for non-strings by Ron Baldwin.
Added new metatype, X for TeXt. Formerly, metatype B for Blob also included text fields. Now 'B' is for binary/image data. 'X' for textual data.
Fixed $this->GetArray() in GetRows().
Oracle and OCI8: 1st parameter is always blank -- now warns if it is filled.
Now hasLimit and hasTop added to indicate whether SELECT * FROM TABLE LIMIT 10 or SELECT TOP 10 * FROM TABLE are supported.
0.94 04 Feb 2001
Added ADORecordSet::GetRows() for compatibility with Microsoft ADO. Synonym for GetArray().
Added new metatype 'R' to represent autoincrement numbers.
Added ADORecordSet.FetchObject() to return a row as an object.
Finally got a Linux box to test PostgreSql. Many fixes.
Fixed copyright misspellings in 0.93.
Fixed mssql MetaColumns type bug.
Worked around odbc bug in PHP4 for sessions.
Fixed many documentation bugs (affected_rows, metadatabases, qstr).
Fixed MySQL timestamp format (removed comma).
Interbase driver did not call ibase_pconnect(). Fixed.
0.93 18 Jan 2002
Fixed GetMenu bug.
Simplified Interbase commit and rollback.
Default behaviour on closing a connection is now to rollback all active transactions.
Added field object handling for array recordset for future XML compatibility.
Added arr2html() to convert array to html table.
0.92 2 Jan 2002
Interbase Commit and Rollback should be working again.
Changed initialisation of ADORecordSet. This is internal and should not affect users. We are doing this to support cached recordsets in the future.
Implemented ADORecordSet_array class. This allows you to simulate a database recordset with an array.
Added UnixDate() and UnixTimeStamp() to ADORecordSet.
0.91 21 Dec 2000
Fixed ODBC so ErrorMsg() is working.
Worked around ADO unrecognised null (0x1) value problem in COM.
Added Sybase support for FetchField() type
Removed debugging code and unneeded html from various files
Changed to javadoc style comments to adodb.inc.php.
Added maxsql as synonym for mysqlt
Now ODBC downloads first 8K of blob by default
0.90 15 Nov 2000
Lots of testing of Microsoft ADO. Should be more stable now.
Added $ADODB_COUNTREC. Set to false for high speed selects.
Added Sybase support. Contributed by Toni Tunkkari (toni.tunkkari#finebyte.com). Bug in Sybase API: GetFields is unable to determine date types.
Changed behaviour of RecordSet.GetMenu() to support size parameter (listbox) properly.
Added emptyDate and emptyTimeStamp to RecordSet class that defines how to represent empty dates.
Added MetaColumns($table) that returns an array of ADOFieldObject's listing the columns of a table.
Added transaction support for PostgresSQL -- thanks to "Eric G. Werk" egw#netguide.dk.
Added adodb-session.php for session support.
0.80 30 Nov 2000
Added support for charSet for interbase. Implemented MetaTables for most databases. PostgreSQL more extensively tested.
0.71 22 Nov 2000
Switched from using require_once to include/include_once for backward compatability with PHP 4.02 and earlier.
0.70 15 Nov 2000
Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP, except in Oracle 7 driver due to a bug in php_oracle.dll.
PostgreSQL database driver contributed by Alberto Cerezal (acerezalp#dbnet.es).
Oci8 driver for Oracle 8 contributed by George Fourlanos (fou#infomap.gr).
Added mysqlt database driver to support MySQL 3.23 which has transaction support.
Oracle default date format (DD-MON-YY) did not match ADOdb default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date.
Error message checking is now included in test suite.
MoveNext() did not check EOF properly -- fixed.
0.60 Nov 8 2000
Fixed some constructor bugs in ODBC and ADO. Added ErrorNo function to ADOConnection class.
0.51 Oct 18 2000
Fixed some interbase bugs.
0.50 Oct 16 2000
Interbase commit/rollback changed to be compatible with PHP 4.03.
CommitTrans( ) will now return true if transactions not supported.
Conversely RollbackTrans( ) will return false if transactions not supported.
0.46 Oct 12Many Oracle compatibility issues fixed.
0.40 Sept 26
Many bug fixes
Now Code for BeginTrans, CommitTrans and RollbackTrans is working. So is the Affected_Rows and Insert_ID. Added above functions to test.php.
ADO type handling was busted in 0.30. Fixed.
Generalised Move( ) so it works will all databases, including ODBC.
0.30 Sept 18
Renamed ADOLoadDB to ADOLoadCode. This is clearer.
Added BeginTrans, CommitTrans and RollbackTrans functions.
Added Affected_Rows() and Insert_ID(), _affectedrows() and _insertID(), ListTables(), ListDatabases(), ListColumns().
Need to add New_ID() and hasInsertID and hasAffectedRows, autoCommit
0.20 Sept 12
Added support for Microsoft's ADO.
Added new field to ADORecordSet -- canSeek
Added new parameter to _fetch($ignore_fields = false). Setting to true will not update fields array for faster performance.
Added new field to ADORecordSet/ADOConnection -- dataProvider to indicate whether a class is derived from odbc or ado.
Changed class ODBCFieldObject to ADOFieldObject -- not documented currently.
Added benchmark.php and testdatabases.inc.php to the test suite.
Added to ADORecordSet FastForward( ) for future high speed scrolling. Not documented.
Realised that ADO's Move( ) uses relative positioning. ADOdb uses absolute.
0.10 Sept 9 2000