1 <html><title>Old Changelog: ADOdb</title><body>
\r
2 <h3>Old Changelog</h3>
\r
4 </p><p><b>3.92 22 Sept 2003</b>
\r
5 </p><p>Added GetAssoc and CacheGetAssoc to connection object.
\r
6 </p><p>Removed TextMax and CharMax functions from adodb.inc.php.
\r
7 </p><p>HasFailedTrans() returned false when trans failed. Fixed.
\r
8 </p><p>Moved perf driver classes into adodb/perf/*.php.
\r
9 </p><p>Misc improvements to performance monitoring, including UI().
\r
10 </p><p>RETVAL in mssql Parameter(), we do not append @ now.
\r
11 </p><p>Added Param($name) to connection class, returns '?' or ":$name", for defining
\r
12 bind parameters portably.
\r
13 </p><p>LogSQL traps affected_rows() and saves its value properly now. Also fixed oci8
\r
14 _stmt and _affectedrows() bugs.
\r
15 </p><p>Session code timestamp check for oci8 works now. Formerly default NLS_DATE_FORMAT
\r
16 stripped off time portion. Thx to Tony Blair (tonanbarbarian#hotmail.com). Also
\r
17 added new $conn->datetime field to oci8, controls whether MetaType() returns
\r
18 'D' ($this->datetime==false) or 'T' ($this->datetime == true) for DATE type.
\r
19 </p><p>Fixed bugs in adodb-cryptsession.inc.php and adodb-session-clob.inc.php.
\r
20 </p><p>Fixed misc bugs in adodb_key_exists, GetInsertSQL() and GetUpdateSQL().
\r
21 </p><p>Tuned include_once handling to reduce file-system checking overhead.
\r
22 </p><p><b>3.91 9 Sept 2003</b>
\r
23 </p><p>Only released to InterAkt
\r
24 </p><p>Added LogSQL() for sql logging and $ADODB_NEWCONNECTION to override factory
\r
25 for driver instantiation.
\r
26 </p><p>Added IfNull($field,$ifNull) function, thx to johnwilk#juno.com
\r
27 </p><p>Added portable substr support.
\r
28 </p><p>Now rs2html() has new parameter, $echo. Set to false to return $html instead
\r
30 </p><p><b>3.90 5 Sept 2003</b>
\r
31 </p><p>First beta of performance monitoring released.
\r
32 </p><p>MySQL supports MetaTable() masking.
\r
33 </p><p>Fixed key_exists() bug in adodb-lib.inc.php
\r
34 </p><p>Added sp_executesql Prepare() support to mssql.
\r
35 </p><p>Added bind support to db2.
\r
36 </p><p>Added swedish language file - Christian Tiberg" christian#commsoft.nu
\r
37 </p><p>Bug in drop index for mssql data dict fixed. Thx to Gert-Rainer Bitterlich.
\r
38 </p><p>Left join setting for oci8 was wrong. Thx to johnwilk#juno.com
\r
39 </p><p><b>3.80 27 Aug 2003</b>
\r
40 </p><p>Patch for PHP 4.3.3 cached recordset csv2rs() fread loop incompatibility.
\r
41 </p><p>Added matching mask for MetaTables. Only for oci8, mssql and postgres currently.
\r
42 </p><p>Rewrite of "oracle" driver connection code, merging with "oci8", by Gaetano.
\r
43 </p><p>Added better debugging for Smart Transactions.
\r
44 </p><p>Postgres DBTimeStamp() was wrongly using TO_DATE. Changed to TO_TIMESTAMP.
\r
45 </p><p>ADODB_FETCH_CASE check pushed to ADONewConnection to allow people to define
\r
46 it after including adodb.inc.php.
\r
47 </p><p>Added portugese (brazilian) to languages. Thx to "Levi Fukumori".
\r
48 </p><p>Removed arg3 parameter from Execute/SelectLimit/Cache* functions.
\r
49 </p><p>Execute() now accepts 2-d array as $inputarray. Also changed docs of fnExecute()
\r
50 to note change in sql query counting with 2-d arrays.
\r
51 </p><p>Added MONEY to MetaType in PostgreSQL.
\r
52 </p><p>Added more debugging output to CacheFlush().
\r
53 </p><p><b>3.72 9 Aug 2003</b>
\r
54 </p><p>Added qmagic($str), which is a qstr($str) that auto-checks for magic quotes
\r
55 and does the right thing...
\r
56 </p><p>Fixed CacheFlush() bug - Thx to martin#gmx.de
\r
57 </p><p>Walt Boring contributed MetaForeignKeys for postgres7.
\r
58 </p><p>_fetch() called _BlobDecode() wrongly in interbase. Fixed.
\r
59 </p><p>adodb_time bug fixed with dates after 2038 fixed by Jason Pell. http://phplens.com/lens/lensforum/msgs.php?id=6980
\r
60 </p><p><b>3.71 4 Aug 2003</b>
\r
61 </p><p>The oci8 driver, MetaPrimaryKeys() did not check the owner correctly when $owner
\r
63 </p><p>Russian language file contributed by "Cyrill Malevanov" cyrill#malevanov.spb.ru.
\r
64 </p><p>Spanish language file contributed by "Horacio Degiorgi" horaciod#codigophp.com.
\r
65 </p><p>Error handling in oci8 bugfix - if there was an error in Execute(), then when
\r
66 calling ErrorNo() and/or ErrorMsg(), the 1st call would return the error, but
\r
67 the 2nd call would return no error.
\r
68 </p><p>Error handling in odbc bugfix. ODBC would always return the last error, even
\r
69 if it happened 5 queries ago. Now we reset the errormsg to '' and errorno to
\r
70 0 everytime before CacheExecute() and Execute().
\r
71 </p><p><b>3.70 29 July 2003</b>
\r
72 </p><p>Added new SQLite driver. Tested on PHP 4.3 and PHP 5.
\r
73 </p><p>Added limited "sapdb" driver support - mainly date support.
\r
74 </p><p>The oci8 driver did not identify NUMBER with no defined precision correctly.
\r
75 </p><p>Added ADODB_FORCE_NULLS, if set, then PHP nulls are converted to SQL nulls
\r
76 in GetInsertSQL/GetUpdateSQL.
\r
77 </p><p>DBDate() and DBTimeStamp() format for postgresql had problems. Fixed.
\r
78 </p><p>Added tableoptions to ChangeTableSQL(). Thx to Mike Benoit.
\r
79 </p><p>Added charset support to postgresql. Thx to Julian Tarkhanov.
\r
80 </p><p>Changed OS check for MS-Windows to prevent confusion with darWIN (MacOS)
\r
81 </p><p>Timestamp format for db2 was wrong. Changed to yyyy-mm-dd-hh.mm.ss.nnnnnn.
\r
82 </p><p>adodb-cryptsession.php includes wrong. Fixed.
\r
83 </p><p>Added MetaForeignKeys(). Supported by mssql, odbc_mssql and oci8.
\r
84 </p><p>Fixed some oci8 MetaColumns/MetaPrimaryKeys bugs. Thx to Walt Boring.
\r
85 </p><p>adodb_getcount() did not init qryRecs to 0. Missing "WHERE" clause checking
\r
86 in GetUpdateSQL fixed. Thx to Sebastiaan van Stijn.
\r
87 </p><p>Added support for only 'VIEWS' and "TABLES" in MetaTables. From Walt Boring.
\r
88 </p><p>Upgraded to adodb-xmlschema.inc.php 0.0.2.
\r
89 </p><p>NConnect for mysql now returns value. Thx to Dennis Verspuij.
\r
90 </p><p>ADODB_FETCH_BOTH support added to interbase/firebird.
\r
91 </p><p>Czech language file contributed by Kamil Jakubovic jake#host.sk.
\r
92 </p><p>PostgreSQL BlobDecode did not use _connectionID properly. Thx to Juraj Chlebec.
\r
93 </p><p>Added some new initialization stuff for Informix. Thx to "Andrea Pinnisi" pinnisi#sysnet.it
\r
94 </p><p>ADODB_ASSOC_CASE constant wrong in sybase _fetch(). Fixed.
\r
95 </p><p><b>3.60 16 June 2003</b>
\r
96 </p><p>We now SET CONCAT_NULL_YIELDS_NULL OFF for odbc_mssql driver to be compat with
\r
98 </p><p>The property $emptyDate missing from connection class. Also changed 1903 to
\r
99 constant (TIMESTAMP_FIRST_YEAR=100). Thx to Sebastiaan van Stijn.
\r
100 </p><p>ADOdb speedup optimization - we now return all arrays by reference.
\r
101 </p><p>Now DBDate() and DBTimeStamp() now accepts the string 'null' as a parameter.
\r
102 Suggested by vincent.
\r
103 </p><p>Added GetArray() to connection class.
\r
104 </p><p>Added not_null check in informix metacolumns().
\r
105 </p><p>Connection parameters for postgresql did not work correctly when port was defined.
\r
106 </p><p>DB2 is now a tested driver, making adodb 100% compatible. Extensive changes
\r
107 to odbc driver for DB2, including implementing serverinfo() and SQLDate(), switching
\r
108 to SQL_CUR_USE_ODBC as the cursor mode, and lastAffectedRows and SelectLimit()
\r
110 </p><p>The odbc driver's FetchField() field names did not obey ADODB_ASSOC_CASE. Fixed.
\r
111 </p><p>Some bugs in adodb_backtrace() fixed.
\r
112 </p><p>Added "INT IDENTITY" type to adorecordset::MetaType() to support odbc_mssql
\r
114 </p><p>MetaColumns() for oci8, mssql, odbc revised to support scale. Also minor revisions
\r
115 to odbc MetaColumns() for vfp and db2 compat.
\r
116 </p><p>Added unsigned support to mysql datadict class. Thx to iamsure.
\r
117 </p><p>Infinite loop in mssql MoveNext() fixed when ADODB_FETCH_ASSOC used. Thx to
\r
118 Josh R, Night_Wulfe#hotmail.com.
\r
119 </p><p>ChangeTableSQL contributed by Florian Buzin.
\r
120 </p><p>The odbc_mssql driver now sets CONCAT_NULL_YIELDS_NULL OFF for compat with
\r
124 <p><b>3.50 19 May 2003</b></p>
\r
125 <p>Fixed mssql compat with FreeTDS. FreeTDS does not implement mssql_fetch_assoc().
\r
126 <p>Merged back connection and recordset code into adodb.inc.php.
\r
127 <p>ADOdb sessions using oracle clobs contributed by achim.gosse#ddd.de. See adodb-session-clob.php.
\r
128 <p>Added /s modifier to preg_match everywhere, which ensures that regex does not
\r
129 stop at /n. Thx Pao-Hsi Huang.
\r
130 <p>Fixed error in metacolumns() for mssql.
\r
131 <p>Added time format support for SQLDate.
\r
132 <p>Image => B added to metatype.
\r
133 <p>MetaType now checks empty($this->blobSize) instead of empty($this).
\r
134 <p>Datadict has beta support for informix, sybase (mapped to mssql), db2 and generic
\r
135 (which is a fudge).
\r
136 <p>BlobEncode for postgresql uses pg_escape_bytea, if available. Needed for compat
\r
138 <p>Added $ADODB_LANG, to support multiple languages in MetaErrorMsg().
\r
139 <p>Datadict can now parse table definition as declarative text.
\r
140 <p>For DataDict, oci8 autoincrement trigger missing semi-colon. Fixed.
\r
141 <p>For DataDict, when REPLACE flag enabled, drop sequence in datadict for autoincrement
\r
142 field in postgres and oci8.s
\r
143 <p>Postgresql defaults to template1 database if no database defined in connect/pconnect.
\r
144 <p>We now clear _resultid in postgresql if query fails.
\r
145 <p><b>3.40 19 May 2003</b></p>
\r
146 <p>Added insert_id for odbc_mssql.
\r
147 <p>Modified postgresql UpdateBlobFile() because it did not work in safe mode.
\r
148 <p>Now connection object is passed to raiseErrorFn as last parameter. Needed by
\r
150 <p>Added StartTrans() and CompleteTrans(). It is recommended that you do not modify
\r
151 transOff, but use the above functions.
\r
152 <p>oci8po now obeys ADODB_ASSOC_CASE settings.
\r
153 <p>Added virtualized error codes, using PEAR DB equivalents. Requires you to manually
\r
154 include adodb-error.inc.php yourself, with MetaError() and MetaErrorMsg($errno).
\r
155 <p>GetRowAssoc for mysql and pgsql were flawed. Fix by Ross Smith.
\r
156 <p>Added to datadict types I1, I2, I4 and I8. Changed datadict type 'T' to map
\r
157 to timestamp instead of datetime for postgresql.
\r
158 <p>Error handling in ExecuteSQLArray(), adodb-datadict.inc.php did not work.
\r
159 <p>We now auto-quote postgresql connection parameters when building connection
\r
161 <p>Added session expiry notification.
\r
162 <p>We now test with odbc mysql - made some changes to odbc recordset constructor.
\r
163 <p>MetaColumns now special cases access and other databases for odbc.
\r
164 <p><b>3.31 17 March 2003</b></p>
\r
165 <p>Added row checking for _fetch in postgres.
\r
166 <p>Added Interval type to MetaType for postgres.
\r
167 <p>Remapped postgres driver to call postgres7 driver internally.
\r
168 <p>Adorecordset_array::getarray() did not return array when nRows >= 0.
\r
169 <p>Postgresql: at times, no error message returned by pg_result_error() but error
\r
170 message returned in pg_last_error(). Recoded again.
\r
171 <p>Interbase blob's now use chunking for updateblob.
\r
172 <p>Move() did not set EOF correctly. Reported by Jorma T.
\r
173 <p>We properly support mysql timestamp fields when we are creating mysql tables
\r
174 using the data-dict interface.
\r
175 <p>Table regex includes backticks character now.
\r
176 <p><b>3.30 3 March 2003</b></p>
\r
177 <p>Added $ADODB_EXTENSION and $ADODB_COMPAT_FETCH constant.
\r
178 <p>Made blank1stItem configurable using syntax "value:text" in GetMenu/GetMenu2.
\r
179 Thx to Gabriel Birke.
\r
180 <p>Previously ADOdb differed from the Microsoft standard because it did not define
\r
181 what to set $this->fields when EOF was reached. Now at EOF, ADOdb sets $this->fields
\r
182 to false for all databases, which is consist with Microsoft's implementation.
\r
183 Postgresql and mysql have always worked this way (in 3.11 and earlier). If you
\r
184 are experiencing compatibility problems (and you are not using postgresql nor
\r
185 mysql) on upgrading to 3.30, try setting the global variables $ADODB_COUNTRECS
\r
186 = true (which is the default) and $ADODB_FETCH_COMPAT = true (this is a new
\r
188 <p>We now check both pg_result_error and pg_last_error as sometimes pg_result_error
\r
189 does not display anything. Iman Mayes
\r
190 <p> We no longer check for magic quotes gpc in Quote().
\r
191 <p> Misc fixes for table creation in adodb-datadict.inc.php. Thx to iamsure.
\r
192 <p> Time calculations use adodb_time library for all negative timestamps due to
\r
193 problems in Red Hat 7.3 or later. Formerly, only did this for Windows.
\r
194 <p> In mssqlpo, we now check if $sql in _query is a string before we change ||
\r
195 to +. This is to support prepared stmts.
\r
196 <p> Move() and MoveLast() internals changed to support to support EOF and $this->fields
\r
198 <p> Added ADODB_FETCH_BOTH support to mssql. Thx to Angel Fradejas afradejas#mediafusion.es
\r
199 <p> We now check if link resource exists before we run mysql_escape_string in
\r
201 <p> Before we flock in csv code, we check that it is not a http url.
\r
202 <p><b>3.20 17 Feb 2003</b></p>
\r
203 <p>Added new Data Dictionary classes for creating tables and indexes. Warning
\r
204 - this is very much alpha quality code. The API can still change. See adodb/tests/test-datadict.php
\r
206 <p>We now ignore $ADODB_COUNTRECS for mysql, because PHP truncates incomplete
\r
207 recordsets when mysql_unbuffered_query() is called a second time.
\r
208 <p>Now postgresql works correctly when $ADODB_COUNTRECS = false.
\r
209 <p>Changed _adodb_getcount to properly support SELECT DISTINCT.
\r
210 <p>Discovered that $ADODB_COUNTRECS=true has some problems with prepared queries
\r
211 - suspect PHP bug.
\r
212 <p>Now GetOne and GetRow run in $ADODB_COUNTRECS=false mode for better performance.
\r
213 <p>Added support for mysql_real_escape_string() and pg_escape_string() in qstr().
\r
214 <p>Added an intermediate variable for mysql _fetch() and MoveNext() to store fields,
\r
215 to prevent overwriting field array with boolean when mysql_fetch_array() returns
\r
217 <p>Made arrays for getinsertsql and getupdatesql case-insensitive. Suggested by
\r
218 Tim Uckun" tim#diligence.com
\r
219 <p><b>3.11 11 Feb 2003</b></p>
\r
220 <p>Added check for ADODB_NEVER_PERSIST constant in PConnect(). If defined, then
\r
221 PConnect() will actually call non-persistent Connect().
\r
222 <p>Modified interbase to properly work with Prepare().
\r
223 <p>Added $this->ibase_timefmt to allow you to change the date and time format.
\r
224 <p>Added support for $input_array parameter in CacheFlush().
\r
225 <p>Added experimental support for dbx, which was then removed when i found that
\r
226 it was slower than using native calls.
\r
227 <p>Added MetaPrimaryKeys for mssql and ibase/firebird.
\r
228 <p>Added new $trim parameter to GetCol and CacheGetCol
\r
229 <p>Uses updated adodb-time.inc.php 0.06.
\r
230 <p><b>3.10 27 Jan 2003</b>
\r
231 <p>Added adodb_date(), adodb_getdate(), adodb_mktime() and adodb-time.inc.php.
\r
232 <p>For interbase, added code to handle unlimited number of bind parameters. From
\r
233 Daniel Hasan daniel#hasan.cl.
\r
234 <p>Added BlobDecode and UpdateBlob for informix. Thx to Fernando Ortiz.
\r
235 <p>Added constant ADODB_WINDOWS. If defined, means that running on Windows.
\r
236 <p>Added constant ADODB_PHPVER which stores php version as a hex num. Removed
\r
237 $ADODB_PHPVER variable.
\r
238 <p>Felho Bacsi reported a minor white-space regular expression problem in GetInsertSQL.
\r
239 <p>Modified ADO to use variant to store _affectedRows
\r
240 <p>Changed ibase to use base class Replace(). Modified base class Replace() to
\r
242 <p>Changed odbc to auto-detect when 0 records returned is wrong due to bad odbc
\r
244 <p>Changed mssql to use datetimeconvert ini setting only when 4.30 or later (does
\r
245 not work in 4.23).
\r
246 <p>ExecuteCursor($stmt, $cursorname, $params) now accepts a new $params array
\r
247 of additional bind parameters -- William Lovaton walovaton#yahoo.com.mx.
\r
248 <p>Added support for sybase_unbuffered_query if ADODB_COUNTRECS == false. Thx
\r
250 <p>Fixed FetchNextObj() bug. Thx to Jorma Tuomainen.
\r
251 <p>We now use SCOPE_IDENTITY() instead of @@IDENTITY for mssql - thx to marchesini#eside.it
\r
252 <p>Changed postgresql movenext logic to prevent illegal row number from being
\r
253 passed to pg_fetch_array().
\r
254 <p>Postgresql initrs bug found by "Bogdan RIPA" bripa#interakt.ro $f1 accidentally
\r
256 <p><b>3.00 6 Jan 2003</b>
\r
257 <p>Fixed adodb-pear.inc.php syntax error.
\r
258 <p>Improved _adodb_getcount() to use SELECT COUNT(*) FROM ($sql) for languages
\r
260 <p>Fixed _adodb_getcount() caching error.
\r
261 <p>Added sql to retrive table and column info for odbc_mssql.
\r
262 <p><strong>2.91 3 Jan 2003</strong>
\r
263 <p>Revised PHP version checking to use $ADODB_PHPVER with legal values 0x4000,
\r
264 0x4050, 0x4200, 0x4300.
\r
265 <p>Added support for bytea fields and oid blobs in postgres by allowing BlobDecode()
\r
266 to detect and convert non-oid fields. Also added BlobEncode to postgres when
\r
267 you want to encode oid blobs.
\r
268 <p>Added blobEncodeType property for connections to inform phpLens what encoding
\r
269 method to use for blobs.
\r
270 <p>Added BlobDecode() and BlobEncode() to base ADOConnection class.
\r
271 <p>Added umask() to _gencachename() when creating directories.
\r
272 <p>Added charPage for ado drivers, so you can set the code page.
\r
274 $conn->charPage = CP_UTF8;
\r
275 $conn->Connect($dsn);
\r
277 <p>Modified _seek in mysql to check for num rows=0.
\r
278 <p>Added to metatypes new informix types for IDS 9.30. Thx Fernando Ortiz.
\r
279 <p>_maxrecordcount returned in CachePageExecute $rsreturn
\r
280 <p>Fixed sybase cacheselectlimit( ) problems
\r
281 <p>MetaColumns() max_length should use precision for types X and C for ms access.
\r
283 <p>Speedup of odbc non-SELECT sql statements.
\r
284 <p>Added support in MetaColumns for Wide Char types for ODBC. We halve max_length
\r
285 if unicode/wide char.
\r
286 <p>Added 'B' to types handled by GetUpdateSQL/GetInsertSQL.
\r
287 <p>Fixed warning message in oci8 driver with $persist variable when using PConnect.
\r
288 <p><b>2.90 11 Dec 2002</b>
\r
289 <p>Mssql and mssqlpo and oci8po now support ADODB_ASSOC_CASE.
\r
290 <p>Now MetaType() can accept a field object as the first parameter.
\r
291 <p>New $arr = $db->ServerInfo( ) function. Returns $arr['description'] which
\r
292 is the string description, and $arr['version'].
\r
293 <p>PostgreSQL and MSSQL speedups for insert/updates.
\r
294 <p> Implemented new SetFetchMode() that removes the need to use $ADODB_FETCH_MODE.
\r
295 Each connection has independant fetchMode.
\r
296 <p>ADODB_ASSOC_CASE now defaults to 2, use native defaults. This is because we
\r
297 would break backward compat for too many applications otherwise.
\r
298 <p>Patched encrypted sessions to use replace()
\r
299 <p>The qstr function supports quoting of nulls when escape character is \
\r
300 <p>Rewrote bits and pieces of session code to check for time synch and improve
\r
302 <p>Added property ADOConnection::hasTransactions = true/false;
\r
303 <p>Added CreateSequence and DropSequence functions
\r
304 <p>Found misplaced MoveNext() in adodb-postgres.inc.php. Fixed.
\r
305 <p>Sybase SelectLimit not reliable because 'set rowcount' not cached - fixed.
\r
306 <p>Moved ADOConnection to adodb-connection.inc.php and ADORecordSet to adodb-recordset.inc.php.
\r
307 This allows us to use doxygen to generate documentation. Doxygen doesn't like
\r
308 the classes in the main adodb.inc.php file for some mysterious reason.
\r
309 <p><b>2.50, 14 Nov 2002</b>
\r
310 <p>Added transOff and transCnt properties for disabling (transOff = true) and
\r
311 tracking transaction status (transCnt>0).
\r
312 <p>Added inputarray handling into _adodb_pageexecute_all_rows - "Ross Smith" RossSmith#bnw.com.
\r
313 <p>Fixed postgresql inconsistencies in date handling.
\r
314 <p>Added support for mssql_fetch_assoc.
\r
315 <p>Fixed $ADODB_FETCH_MODE bug in odbc MetaTables() and MetaPrimaryKeys().
\r
316 <p>Accidentally declared UnixDate() twice, making adodb incompatible with php
\r
318 <p>Fixed pager problems with some databases that returned -1 for _currentRow on
\r
319 MoveLast() by switching to MoveNext() in adodb-lib.inc.php.
\r
320 <p>Also fixed uninited $discard in adodb-lib.inc.php.
\r
321 <p><b>2.43, 25 Oct 2002</b></p>
\r
322 Added ADODB_ASSOC_CASE constant to better support ibase and odbc field names.
\r
323 <p>Added support for NConnect() for oracle OCINLogin.
\r
324 <p>Fixed NumCols() bug.
\r
325 <p>Changed session handler to use Replace() on write.
\r
326 <p>Fixed oci8 SelectLimit aggregate function bug again.
\r
327 <p>Rewrote pivoting code.
\r
328 <p><b>2.42, 4 Oct 2002</b></p>
\r
329 <p>Fixed ibase_fetch() problem with nulls. Also interbase now does automatic blob
\r
330 decoding, and is backward compatible. Suggested by Heinz Hombergs heinz#hhombergs.de.
\r
331 <p>Fixed postgresql MoveNext() problems when called repeatedly after EOF. Also
\r
332 suggested by Heinz Hombergs.
\r
333 <p>PageExecute() does not rewrite queries if SELECT DISTINCT is used. Requested
\r
335 <p>Added additional fixes to oci8 SelectLimit handling with aggregate functions
\r
336 - thx to Christian Bugge for reporting the problem.
\r
337 <p><b>2.41, 2 Oct 2002</b></p>
\r
338 <p>Fixed ADODB_COUNTRECS bug in odbc. Thx to Joshua Zoshi jzoshi#hotmail.com.
\r
339 <p>Increased buffers for adodb-csvlib.inc.php for extremely long sql from 8192
\r
341 <p>Revised pivottable.inc.php code. Added better support for aggregate fields.
\r
342 <p>Fixed mysql text/blob types problem in MetaTypes base class - thx to horacio
\r
344 <p>Added SQLDate($fmt,$date) function, which allows an sql date format string
\r
345 to be generated - useful for group by's.
\r
346 <p>Fixed bug in oci8 SelectLimit when offset>100.
\r
347 <p><b>2.40 4 Sept 2002</b></p>
\r
348 <p>Added new NLS_DATE_FORMAT property to oci8. Suggested by Laurent NAVARRO ln#altidev.com
\r
349 <p>Now use bind parameters in oci8 selectlimit for better performance.
\r
350 <p>Fixed interbase replaceQuote for dialect != 1. Thx to "BEGUIN Pierre-Henri
\r
351 - INFOCOB" phb#infocob.com.
\r
352 <p>Added white-space check to QA.
\r
353 <p>Changed unixtimestamp to support fractional seconds (we always round down/floor
\r
354 the seconds). Thanks to beezly#beezly.org.uk.
\r
355 <p>Now you can set the trigger_error type your own user-defined type in adodb-errorhandler.inc.php.
\r
356 Suggested by Claudio Bustos clbustos#entelchile.net.
\r
357 <p>Added recordset filters with rsfilter.inc.php.
\r
358 <p>$conn->_rs2rs does not create a new recordset when it detects it is of type
\r
359 array. Some trickery there as there seems to be a bug in Zend Engine
\r
360 <p>Added render_pagelinks to adodb-pager.inc.php. Code by "Pablo Costa" pablo#cbsp.com.br.
\r
361 <p>MetaType() speedup in adodb.inc.php by using hashing instead of switch. Best
\r
362 performance if constant arrays are supported, as they are in PHP5.
\r
363 <p>adodb-session.php now updates only the expiry date if the crc32 check indicates
\r
364 that the data has not been modified.
\r
365 <p><b>2.31 20 Aug 2002</b></p>
\r
366 <p>Made changes to pivottable.inc.php due to daniel lucuzaeu's suggestions (we sum the pivottable column if desired).
\r
367 <p>Fixed ErrorNo() in postgres so it does not depend on _errorMsg property.
\r
368 <p>Robert Tuttle added support for oracle cursors. See ExecuteCursor().
\r
369 <p>Fixed Replace() so it works with mysql when updating record where data has not changed. Reported by
\r
370 Cal Evans (cal#calevans.com).
\r
371 <p><b>2.30 1 Aug 2002</b></p>
\r
372 <p>Added pivottable.inc.php. Thanks to daniel.lucazeau#ajornet.com for the original
\r
374 <p>Added ADOConnection::outp($msg,$newline) to output error and debugging messages. Now
\r
375 you can override this using the ADODB_OUTP constant and use your own output handler.
\r
376 <p>Changed == to === for 'null' comparison. Reported by ericquil#yahoo.com
\r
377 <p>Fixed mssql SelectLimit( ) bug when distinct used.
\r
378 <p><b>2.30 1 Aug 2002</b></p>
\r
379 <p>New GetCol() and CacheGetCol() from ross#bnw.com that returns the first field as a 1 dim array.
\r
380 <p>We have an empty recordset, but RecordCount() could return -1. Fixed. Reported by "Jonathan Polansky" jonathan#polansky.com.
\r
381 <p>We now check for session variable changes using strlen($sessval).crc32($sessval).
\r
382 Formerly we only used crc32().
\r
383 <p>Informix SelectLimit() problem with $ADODB_COUNTRECS fixed.
\r
384 <p>Fixed informix SELECT FIRST x DISTINCT, and not SELECT DISTINCT FIRST x - reported by F Riosa
\r
385 <p>Now default adodb error handlers ignores error if @ used.
\r
386 <p>If you set $conn->autoRollback=true, we auto-rollback persistent connections for odbc, mysql, oci8, mssql.
\r
387 Default for autoRollback is false. No need to do so for postgres.
\r
388 As interbase requires a transaction id (what a flawed api), we don't do it for interbase.
\r
389 <p>Changed PageExecute() to use non-greedy preg_match when searching for "FROM" keyword.
\r
390 <p><b>2.20 9 July 2002</b></p>
\r
391 <p>Added CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
\r
392 <p>Added $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs
\r
393 date offsets. Useful for scheduling appointments.
\r
394 <p>Added connection properties: leftOuter, rightOuter that hold left and right
\r
395 outer join operators.
\r
396 <p>Added connection property: ansiOuter to indicate whether ansi outer joins supported.
\r
397 <p>New driver <i>mssqlpo</i>, the portable mssql driver, which converts string
\r
398 concat operator from || to +.
\r
399 <p>Fixed ms access bug - SelectLimit() did not support ties - fixed.
\r
400 <p>Karsten Kraus (Karsten.Kraus#web.de), contributed error-handling code to ADONewConnection.
\r
401 Unfortunately due to backward compat problems, had to rollback most of the changes.
\r
402 <p>Added new parameter to GetAssoc() to allow returning an array of key-value pairs,
\r
403 ignoring any additional columns in the recordset. Off by default.
\r
404 <p>Corrected mssql $conn->sysDate to return only date using convert().
\r
405 <p>CacheExecute() improved debugging output.
\r
406 <p>Changed rs2html() so newlines are converted to BR tags. Also optimized rs2html() based
\r
407 on feedback by "Jerry Workman" jerry#mtncad.com.
\r
408 <p>Added support for Replace() with Interbase, using DELETE and INSERT.
\r
409 <p>Some minor optimizations (mostly removing & references when passing arrays).
\r
410 <p>Changed GenID() to allows id's larger than the size of an integer.
\r
411 <p>Added force_session property to oci8 for better updateblob() support.
\r
412 <p>Fixed PageExecute() which did not work properly with sql containing GROUP BY.
\r
413 <p><b>2.12 12 June 2002</b></p>
\r
414 <p>Added toexport.inc.php to export recordsets in CSV and tab-delimited format.
\r
415 <p>CachePageExecute() does not work - fixed - thx John Huong.
\r
416 <p>Interbase aliases not set properly in FetchField() - fixed. Thx Stefan Goethals.
\r
417 <p>Added cache property to adodb pager class. The number of secs to cache recordsets.
\r
418 <p>SQL rewriting bug in pageexecute() due to skipping of newlines due to missing /s modifier. Fixed.
\r
419 <p>Max size of cached recordset due to a bug was 256000 bytes. Fixed.
\r
420 <p>Speedup of 1st invocation of CacheExecute() by tuning code.
\r
421 <p>We compare $rewritesql with $sql in pageexecute code in case of rewrite failure.
\r
422 <p><b>2.11 7 June 2002</b></p>
\r
423 <p>Fixed PageExecute() rewrite sql problem - COUNT(*) and ORDER BY don't go together with
\r
424 mssql, access and postgres. Thx to Alexander Zhukov alex#unipack.ru
\r
425 <p>DB2 support for CHARACTER type added - thx John Huong huongch#bigfoot.com
\r
426 <p>For ado, $argProvider not properly checked. Fixed - kalimero#ngi.it
\r
427 <p>Added $conn->Replace() function for update with automatic insert if the record does not exist.
\r
428 Supported by all databases except interbase.
\r
429 <p><b>2.10 4 June 2002</b></p>
\r
430 <p>Added uniqueSort property to indicate mssql ORDER BY cols must be unique.
\r
431 <p>Optimized session handler by crc32 the data. We only write if session data has changed.
\r
432 <p>adodb_sess_read in adodb-session.php now returns ''correctly - thanks to Jorma Tuomainen, webmaster#wizactive.com
\r
433 <p>Mssql driver did not throw EXECUTE errors correctly because ErrorMsg() and ErrorNo() called in wrong order.
\r
434 Pointed out by Alexios Fakos. Fixed.
\r
435 <p>Changed ado to use client cursors. This fixes BeginTran() problems with ado.
\r
436 <p>Added handling of timestamp type in ado.
\r
437 <p>Added to ado_mssql support for insert_id() and affected_rows().
\r
438 <p>Added support for mssql.datetimeconvert=0, available since php 4.2.0.
\r
439 <p>Made UnixDate() less strict, so that the time is ignored if present.
\r
440 <p>Changed quote() so that it checks for magic_quotes_gpc.
\r
441 <p>Changed maxblobsize for odbc to default to 64000.
\r
442 <p><b>2.00 13 May 2002</b></p>
\r
443 <p>Added drivers <i>informix72</i> for pre-7.3 versions, and <i>oci805</i> for
\r
444 oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers
\r
446 <p>Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode.
\r
447 <p>Proper support for blobs in mssql. Also revised blob support code
\r
448 is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency.
\r
449 <p>Added support for changed odbc_fetch_into api in php 4.2.0
\r
450 with $conn->_has_stupid_odbc_fetch_api_change.
\r
451 <p>Fixed spelling of tablock locking hint in GenID( ) for mssql.
\r
452 <p>Added RowLock( ) to several databases, including oci8, informix, sybase, etc.
\r
453 Fixed where error in mssql RowLock().
\r
454 <p>Added sysDate and sysTimeStamp properties to most database drivers. These are the sql
\r
455 functions/constants for that database that return the current date and current timestamp, and
\r
456 are useful for portable inserts and updates.
\r
457 <p>Support for RecordCount() caused date handling in sybase and mssql to break.
\r
458 Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for
\r
459 both databases. Generalized using arrayClass property. Also to support RecordCount(),
\r
460 changed metatype handling for ado drivers. Now the type returned in FetchField
\r
461 is no longer a number, but the 1-char data type returned by MetaType.
\r
462 At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats.
\r
463 Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling.
\r
464 Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM).
\r
465 <p>Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com
\r
466 <p>Added $ok parameter to CommitTrans($ok) for easy rollbacks.
\r
467 <p>Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE.
\r
468 <p>Some odbc drivers did not call the base connection class constructor. Fixed.
\r
469 <p>Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations.
\r
471 <p><b>1.99 21 April 2002</b></p>
\r
472 <p>Added emulated RecordCount() to all database drivers if $ADODB_COUNTRECS = true
\r
473 (which it is by default). Inspired by Cristiano Duarte (cunha17#uol.com.br).
\r
474 <p>Unified stored procedure support for mssql and oci8. Parameter() and PrepareSP()
\r
475 functions implemented.
\r
476 <p>Added support for SELECT FIRST in informix, modified hasTop property to support
\r
478 <p>Changed csv driver to handle updates/deletes/inserts properly (when Execute() returns true).
\r
479 Bind params also work now, and raiseErrorFn with csv driver. Added csv driver to QA process.
\r
480 <p>Better error checking in oci8 UpdateBlob() and UpdateBlobFile().
\r
481 <p>Added TIME type to MySQL - patch by Manfred h9125297#zechine.wu-wien.ac.at
\r
482 <p>Prepare/Execute implemented for Interbase/Firebird
\r
483 <p>Changed some regular expressions to be anchored by /^ $/ for speed.
\r
484 <p>Added UnixTimeStamp() and UnixDate() to ADOConnection(). Now these functions
\r
485 are in both ADOConnection and ADORecordSet classes.
\r
486 <p>Empty recordsets were not cached - fixed.
\r
487 <p>Thanks to Gaetano Giunta (g.giunta#libero.it) for the oci8 code review. We
\r
488 didn't agree on everything, but i hoped we agreed to disagree!
\r
489 <p><b>1.90 6 April 2002</b></p>
\r
490 <p>Now all database drivers support fetch modes ADODB_FETCH_NUM and ADODB_FETCH_ASSOC, though
\r
491 still not fully tested. Eg. Frontbase, Sybase, Informix.
\r
492 <p>NextRecordSet() support for mssql. Contributed by "Sven Axelsson" sven.axelsson#bokochwebb.se
\r
493 <p>Added blob support for SQL Anywhere. Contributed by Wade Johnson wade#wadejohnson.de
\r
494 <p>Fixed some security loopholes in server.php. Server.php also supports fetch mode.
\r
495 <p>Generalized GenID() to support odbc and mssql drivers. Mssql no longer generates GUID's.
\r
496 <p>Experimental RowLock($table,$where) for mssql.
\r
497 <p>Properly implemented Prepare() in oci8 and ODBC.
\r
498 <p>Added Bind() support to oci8 to support Prepare().
\r
499 <p>Improved error handler. Catches CacheExecute() and GenID() errors now.
\r
500 <p>Now if you are running php from the command line, debugging messages do not output html formating.
\r
501 Not 100% complete, but getting there.
\r
502 <p><b>1.81 22 March 2002</b></p>
\r
503 <p>Restored default $ADODB_FETCH_MODE = ADODB_FETCH_DEFAULT for backward compatibility.
\r
504 <p>SelectLimit for oci8 improved - Our FIRST_ROWS optimization now does not overwrite existing hint.
\r
505 <p>New Sybase SQL Anywhere driver. Contributed by Wade Johnson wade#wadejohnson.de
\r
506 <p><b>1.80 15 March 2002</b></p>
\r
507 <p>Redesigned directory structure of ADOdb files. Added new driver directory where
\r
508 all database drivers reside.
\r
509 <p>Changed caching algorithm to create subdirectories. Now we scale better.
\r
510 <p>Informix driver now supports insert_id(). Contribution by "Andrea Pinnisi" pinnisi#sysnet.it
\r
511 <p>Added experimental ISO date and FetchField support for informix.
\r
512 <p>Fixed a quoting bug in Execute() with bind parameters, causing problems with blobs.
\r
513 <p>Mssql driver speedup by 10-15%.
\r
514 <p>Now in CacheExecute($secs2cache,$sql,...), $secs2cache is optional. If missing, it will
\r
515 take the value defined in $connection->cacheSecs (default is 3600 seconds). Note that
\r
516 CacheSelectLimit(), the secs2cache is still compulsory - sigh.
\r
517 <p>Sybase SQL Anywhere driver (using ODBC) contributed by Wade Johnson wade#wadejohnson.de
\r
518 <p><b>1.72 8 March 2002</b></p>
\r
519 <p>Added @ when returning Fields() to prevent spurious error - "Michael William Miller" mille562#pilot.msu.edu
\r
520 <p>MetaDatabases() for postgres contributed by Phil pamelant#nerim.net
\r
521 <p>Mitchell T. Young (mitch#youngfamily.org) contributed informix driver.
\r
522 <p>Fixed rs2html() problem. I cannot reproduce, so probably a problem with pre PHP 4.1.0 versions,
\r
523 when supporting new ADODB_FETCH_MODEs.
\r
524 <p>Mattia Rossi (mattia#technologist.com) contributed BlobDecode() and UpdateBlobFile() for postgresql
\r
525 using the postgres specific pg_lo_import()/pg_lo_open() - i don't use them but hopefully others will
\r
526 find this useful. See <a href="http://phplens.com/lens/lensforum/msgs.php?id=1262">this posting</a>
\r
527 for an example of usage.
\r
528 <p>Added UpdateBlobFile() for uploading files to a database.
\r
529 <p>Made UpdateBlob() compatible with oci8po driver.
\r
530 <p>Added noNullStrings support to oci8 driver. Oracle changes all ' ' strings to nulls,
\r
531 so you need to set strings to ' ' to prevent the nullifying of strings. $conn->noNullStrings = true;
\r
532 will do this for you automatically. This is useful when you define a char column as NOT NULL.
\r
533 <p>Fixed UnixTimeStamp() bug - wasn't setting minutes and seconds properly. Patch from Agusti Fita i Borrell agusti#anglatecnic.com.
\r
534 <p>Toni Tunkkari added patch for sybase dates. Problem with spaces in day part of date fixed.
\r
535 <p><b>1.71 18 Jan 2002</b></p>
\r
536 <p>Sequence start id support. Now $conn->Gen_ID('seqname', 50) to start sequence from 50.
\r
537 <p>CSV driver fix for selectlimit, from Andreas - akaiser#vocote.de.
\r
538 <P>Gam3r spotted that a global variable was undefined in the session handler.
\r
539 <p>Mssql date regex had error. Fixed - reported by Minh Hoang vb_user#yahoo.com.
\r
540 <p>DBTimeStamp() and DBDate() now accept iso dates and unix timestamps. This means
\r
541 that the PostgreSQL handling of dates in GetInsertSQL() and GetUpdateSQL() can
\r
542 be removed. Also if these functions are passed '' or null or false, we return a SQL null.
\r
543 <p>GetInsertSQL() and GetUpdateSQL() now accept a new parameter, $magicq to
\r
544 indicate whether quotes should be inserted based on magic quote settings - suggested by
\r
546 <p>Reformated docs slightly based on suggestions by Chris Small.
\r
547 <p><b>1.65 28 Dec 2001</b></p>
\r
548 <p>Fixed borland_ibase class naming bug.
\r
549 <p>Now instead of using $rs->fields[0] internally, we use reset($rs->fields) so
\r
550 that we are compatible with ADODB_FETCH_ASSOC mode. Reported by Nico S.
\r
551 <p>Changed recordset constructor and _initrs() for oci8 so that it returns the field definitions even
\r
552 if no rows in the recordset. Reported by Rick Hickerson (rhickers#mv.mv.com).
\r
553 <p>Improved support for postgresql in GetInsertSQL and GetUpdateSQL by
\r
554 "mike" mike#partner2partner.com and "Ryan Bailey" rebel#windriders.com
\r
555 <p><b>1.64 20 Dec 2001</b></p>
\r
556 <p>Danny Milosavljevic <danny.milo#gmx.net> added some patches for MySQL error handling
\r
557 and displaying default values.
\r
558 <p>Fixed some ADODB_FETCH_BOTH inconsistencies in odbc and interbase.
\r
559 <p>Added more tests to test suite to cover ADODB_FETCH_* and ADODB_ERROR_HANDLER.
\r
560 <p>Added firebird (ibase) driver
\r
561 <p>Added borland_ibase driver for interbase 6.5
\r
562 <p><b>1.63 13 Dec 2001</b></p>
\r
563 Absolute to the adodb-lib.inc.php file not set properly. Fixed.<p>
\r
565 <p><b>1.62 11 Dec 2001</b></p>
\r
566 <p>Major speedup of ADOdb for low-end web sites by reducing the php code loading and compiling
\r
567 cycle. We conditionally compile not so common functions.
\r
568 Moved csv code to adodb-csvlib.inc.php to reduce adodb.inc.php parsing. This file
\r
569 is loaded only when the csv/proxy driver is used, or CacheExecute() is run.
\r
570 Also moved PageExecute(), GetSelectSQL() and GetUpdateSQL() core code to adodb-lib.inc.php.
\r
571 This reduced the 70K main adodb.inc.php file to 55K, and since at least 20K of the file
\r
572 is comments, we have reduced 50K of code in adodb.inc.php to 35K. There
\r
573 should be 35% reduction in memory and thus 35% speedup in compiling the php code for the
\r
574 main adodb.inc.php file.
\r
575 <p>Highly tuned SelectLimit() for oci8 for massive speed improvements on large files.
\r
576 Selecting 20 rows starting from the 20,000th row of a table is now 7 times faster.
\r
577 Thx to Tomas V V Cox.
\r
578 <p>Allow . and # in table definitions in GetInsertSQL and GetUpdateSQL.
\r
579 See ADODB_TABLE_REGEX constant. Thx to Ari Kuorikoski.
\r
580 <p>Added ADODB_PREFETCH_ROWS constant, defaulting to 10. This determines the number
\r
581 of records to prefetch in a SELECT statement. Only used by oci8.</p>
\r
582 <p>Added high portability Oracle class called oci8po. This uses ? for bind variables, and
\r
583 lower cases column names.</p>
\r
584 <p>Now all database drivers support $ADODB_FETCH_MODE, including interbase, ado, and odbc:
\r
585 ADODB_FETCH_NUM and ADODB_FETCH_ASSOC. ADODB_FETCH_BOTH is not fully implemented for all
\r
587 <p><b>1.61 Nov 2001</b></p>
\r
588 <p>Added PO_RecordCount() and PO_Insert_ID(). PO stands for portable. Pablo Roca
\r
589 [pabloroca#mvps.org]</p>
\r
590 <p>GenID now returns 0 if not available. Safer is that you should check $conn->hasGenID
\r
591 for availability.</p>
\r
592 <p>M'soft ADO we now correctly close recordset in _close() peterd#telephonetics.co.uk</p>
\r
593 <p>MSSQL now supports GenID(). It generates a 16-byte GUID from mssql newid()
\r
595 <p>Changed ereg_replace to preg_replace in SelectLimit. This is a fix for mssql.
\r
596 Ereg doesn't support t or n! Reported by marino Carlos xaplo#postnuke-espanol.org</p>
\r
597 <p>Added $recordset->connection. This is the ADOConnection object for the recordset.
\r
598 Works with cached and normal recordsets. Surprisingly, this had no affect on performance!</p>
\r
599 <p><b>1.54 15 Nov 2001</b></p>
\r
600 Fixed some more bugs in PageExecute(). I am getting sick of bug in this and will have to
\r
601 reconsider my QA here. The main issue is that I don't use PageExecute() and
\r
602 to check whether it is working requires a visual inspection of the html generated currently.
\r
603 It is possible to write a test script but it would be quite complicated :(
\r
604 <p> More speedups of SelectLimit() for DB2, Oci8, access, vfp, mssql.
\r
607 <p><b>1.53 7 Nov 2001</b></p>
\r
608 Added support for ADODB_FETCH_ASSOC for ado and odbc drivers.<p>
\r
609 Tuned GetRowAssoc(false) in postgresql and mysql.<p>
\r
610 Stephen Van Dyke contributed ADOdb icon, accepted with some minor mods.<p>
\r
611 Enabled Affected_Rows() for postgresql<p>
\r
612 Speedup for Concat() using implode() - Benjamin Curtis ben_curtis#yahoo.com<p>
\r
613 Fixed some more bugs in PageExecute() to prevent infinite loops<p>
\r
614 <p><b>1.52 5 Nov 2001</b></p>
\r
615 Spelling error in CacheExecute() caused it to fail. $ql should be $sql in line 625!<p>
\r
616 Added fixes for parsing [ and ] in GetUpdateSQL().
\r
617 <p><b>1.51 5 Nov 2001</b></p>
\r
618 <p>Oci8 SelectLimit() speedup by using OCIFetch().
\r
619 <p>Oci8 was mistakenly reporting errors when $db->debug = true.
\r
620 <p>If a connection failed with ODBC, it was not correctly reported - fixed.
\r
621 <p>_connectionID was inited to -1, changed to false.
\r
622 <p>Added $rs->FetchRow(), to simplify API, ala PEAR DB
\r
623 <p>Added PEAR DB compat mode, which is still faster than PEAR! See adodb-pear.inc.php.
\r
624 <p>Removed postgres pconnect debugging statement.
\r
625 <p><b>1.50 31 Oct 2001</b></p>
\r
626 <p>ADOdbConnection renamed to ADOConnection, and ADOdbFieldObject to ADOFieldObject.
\r
627 <p>PageExecute() now checks for empty $rs correctly, and the errors in the docs on this subject have been fixed.
\r
628 <p>odbc_error() does not return 6 digit error correctly at times. Implemented workaround.
\r
629 <p>Added ADORecordSet_empty class. This will speedup INSERTS/DELETES/UPDATES because the return
\r
630 object created is much smaller.
\r
631 <p>Added Prepare() to odbc, and oci8 (but doesn't work properly for oci8 still).
\r
632 <p>Made pgsql a synonym for postgre7, and changed SELECT LIMIT to use OFFSET for compat with
\r
634 <p>Revised adodb-cryptsession.php thanks to Ari.
\r
635 <p>Set resources to false on _close, to force freeing of resources.
\r
636 <p>Added adodb-errorhandler.inc.php, adodb-errorpear.inc.php and raiseErrorFn on Freek's urging.
\r
637 <p>GetRowAssoc($toUpper=true): $toUpper added as default.
\r
638 <p>Errors when connecting to a database were not captured formerly. Now we do it correctly.
\r
639 <p><b>1.40 19 September 2001</b></p>
\r
640 <p>PageExecute() to implement page scrolling added. Code and idea by Iván Oliva.</p>
\r
641 <p>Some minor postgresql fixes.</p>
\r
642 <p>Added sequence support using GenID() for postgresql, oci8, mysql, interbase.</p>
\r
643 <p>Added UpdateBlob support for interbase (untested).</p>
\r
644 <p>Added encrypted sessions (see adodb-cryptsession.php). By Ari Kuorikoski <kuoriari#finebyte.com></p>
\r
645 <p><b>1.31 21 August 2001</b></p>
\r
646 <p>Many bug fixes thanks to "GaM3R (Cameron)" <gamr#outworld.cx>. Some session changes due to Gam3r.
\r
647 <p>Fixed qstr() to quote also.
\r
648 <p>rs2html() now pretty printed.
\r
649 <p>Jonathan Younger jyounger#unilab.com contributed the great idea GetUpdateSQL() and GetInsertSQL() which
\r
650 generates SQL to update and insert into a table from a recordset. Modify the recordset fields
\r
651 array, then can this function to generate the SQL (the SQL is not executed).
\r
652 <p>"Nicola Fankhauser" <nicola.fankhauser#couniq.com> found some bugs in date handling for mssql.</p>
\r
653 <p>Added minimal Oracle support for LOBs. Still under development.</p>
\r
654 Added $ADODB_FETCH_MODE so you can control whether recordsets return arrays which are
\r
655 numeric, associative or both. This is a global variable you set. Currently only MySQL, Oci8, Postgres
\r
656 drivers support this.
\r
657 <p>PostgreSQL properly closes recordsets now. Reported by several people.
\r
659 Added UpdateBlob() for Oracle. A hack to make it easier to save blobs.
\r
661 Oracle timestamps did not display properly. Fixed.
\r
662 <p><b>1.20 6 June 2001</b></p>
\r
663 <p>Now Oracle can connect using tnsnames.ora or server and service name</p>
\r
664 <p>Extensive Oci8 speed optimizations.
\r
665 Oci8 code revised to support variable binding, and /*+ FIRST_ROWS */ hint.</p>
\r
666 <p>Worked around some 4.0.6 bugs in odbc_fetch_into().</p>
\r
667 <p>Paolo S. Asioli paolo.asioli#libero.it suggested GetRowAssoc().</p>
\r
668 <p>Escape quotes for oracle wrongly set to '. Now '' is used.</p>
\r
669 <p>Variable binding now works in ODBC also.</p>
\r
670 <p>Jumped to version 1.20 because I don't like 13 :-)</p>
\r
671 <p><b>1.12 6 June 2001</b></p>
\r
672 <p>Changed $ADODB_DIR to ADODB_DIR constant to plug a security loophole.</p>
\r
673 <p>Changed _close() to close persistent connections also. Prevents connection leaks.</p>
\r
674 <p>Major revision of oracle and oci8 drivers.
\r
675 Added OCI_RETURN_NULLS and OCI_RETURN_LOBS to OCIFetchInto(). BLOB, CLOB and VARCHAR2 recognition
\r
676 in MetaType() improved. MetaColumns() returns columns in correct sort order.</p>
\r
677 <p>Interbase timestamp input format was wrong. Fixed.</p>
\r
678 <p><b>1.11 20 May 2001</b></p>
\r
679 <p>Improved file locking for Windows.</p>
\r
680 <p>Probabilistic flushing of cache to avoid avalanche updates when cache timeouts.</p>
\r
681 <p>Cached recordset timestamp not saved in some scenarios. Fixed.</p>
\r
682 <p><b>1.10 19 May 2001</b></p>
\r
683 <p>Added caching. CacheExecute() and CacheSelectLimit().
\r
684 <p>Added csv driver. See <a href="http://php.weblogs.com/adodb_csv">http://php.weblogs.com/ADODB_csv</a>.
\r
685 <p>Fixed SelectLimit(), SELECT TOP not working under certain circumstances.
\r
686 <p>Added better Frontbase support of MetaTypes() by Frank M. Kromann.
\r
687 <p><b>1.01 24 April 2001</b></p>
\r
688 <p>Fixed SelectLimit bug. not quoted properly.
\r
689 <p>SelectLimit: SELECT TOP -1 * FROM TABLE not support by Microsoft. Fixed.</p>
\r
690 <p>GetMenu improved by glen.davies#cce.ac.nz to support multiple hilited items<p>
\r
691 <p>FetchNextObject() did not work with only 1 record returned. Fixed bug reported by $tim#orotech.net</p>
\r
692 <p>Fixed mysql field max_length problem. Fix suggested by Jim Nicholson (jnich#att.com)</p>
\r
693 <p><b>1.00 16 April 2001</b></p>
\r
694 <p>Given some brilliant suggestions on how to simplify ADOdb by akul. You no longer need to
\r
695 setup $ADODB_DIR yourself, and ADOLoadCode() is automatically called by ADONewConnection(),
\r
696 simplifying the startup code.</p>
\r
697 <p>FetchNextObject() added. Suggested by Jakub Marecek. This makes FetchObject() obsolete, as
\r
698 this is more flexible and powerful.</p>
\r
699 <p>Misc fixes to SelectLimit() to support Access (top must follow distinct) and Fields()
\r
700 in the array recordset. From Reinhard Balling.</p>
\r
701 <p><b>0.96 27 Mar 2001</b></p>
\r
702 <p>ADOConnection Close() did not return a value correctly. Thanks to akul#otamedia.com.</p>
\r
703 <p>When the horrible magic_quotes is enabled, back-slash () is changed to double-backslash (\).
\r
704 This doesn't make sense for Microsoft/Sybase databases. We fix this in qstr().</p>
\r
705 <p>Fixed Sybase date problem in UnixDate() thanks to Toni Tunkkari. Also fixed MSSQL problem
\r
706 in UnixDate() - thanks to milhouse31#hotmail.com.</p>
\r
707 <p>MoveNext() moved to leaf classes for speed in MySQL/PostgreSQL. 10-15% speedup.</p>
\r
708 <p>Added null handling in bindInputArray in Execute() -- Ron Baldwin suggestion.</p>
\r
709 <p>Fixed some option tags. Thanks to john#jrmstudios.com.</p>
\r
710 <p><b>0.95 13 Mar 2001</b></p>
\r
711 <p>Added postgres7 database driver which supports LIMIT and other version 7 stuff in the future.</p>
\r
712 <p>Added SelectLimit to ADOConnection to simulate PostgreSQL's "select * from table limit 10 offset 3".
\r
713 Added helper function GetArrayLimit() to ADORecordSet.</p>
\r
714 <p>Fixed mysql metacolumns bug. Thanks to Freek Dijkstra (phpeverywhere#macfreek.com).</p>
\r
715 <p>Also many PostgreSQL changes by Freek. He almost rewrote the whole PostgreSQL driver!</p>
\r
716 <p>Added fix to input parameters in Execute for non-strings by Ron Baldwin.</p>
\r
717 <p>Added new metatype, X for TeXt. Formerly, metatype B for Blob also included
\r
718 text fields. Now 'B' is for binary/image data. 'X' for textual data.</p>
\r
719 <p>Fixed $this->GetArray() in GetRows().</p>
\r
720 <p>Oracle and OCI8: 1st parameter is always blank -- now warns if it is filled.</p>
\r
721 <p>Now <i>hasLimit</i> and <i>hasTop</i> added to indicate whether
\r
722 SELECT * FROM TABLE LIMIT 10 or SELECT TOP 10 * FROM TABLE are supported.</p>
\r
723 <p><b>0.94 04 Feb 2001</b></p>
\r
724 <p>Added ADORecordSet::GetRows() for compatibility with Microsoft ADO. Synonym for GetArray().</p>
\r
725 <p>Added new metatype 'R' to represent autoincrement numbers.</p>
\r
726 <p>Added ADORecordSet.FetchObject() to return a row as an object.</p>
\r
727 <p>Finally got a Linux box to test PostgreSql. Many fixes.</p>
\r
728 <p>Fixed copyright misspellings in 0.93.</p>
\r
729 <p>Fixed mssql MetaColumns type bug.</p>
\r
730 <p>Worked around odbc bug in PHP4 for sessions.</p>
\r
731 <p>Fixed many documentation bugs (affected_rows, metadatabases, qstr).</p>
\r
732 <p>Fixed MySQL timestamp format (removed comma).</p>
\r
733 <p>Interbase driver did not call ibase_pconnect(). Fixed.</p>
\r
734 <p><b>0.93 18 Jan 2002</b></p>
\r
735 <p>Fixed GetMenu bug.</p>
\r
736 <p>Simplified Interbase commit and rollback.</p>
\r
737 <p>Default behaviour on closing a connection is now to rollback all active transactions.</p>
\r
738 <p>Added field object handling for array recordset for future XML compatibility.</p>
\r
739 <p>Added arr2html() to convert array to html table.</p>
\r
740 <p><b>0.92 2 Jan 2002</b></p>
\r
741 <p>Interbase Commit and Rollback should be working again.</p>
\r
742 <p>Changed initialisation of ADORecordSet. This is internal and should not affect users. We
\r
743 are doing this to support cached recordsets in the future.</p>
\r
745 <p>Implemented ADORecordSet_array class. This allows you to simulate a database recordset
\r
747 <p>Added UnixDate() and UnixTimeStamp() to ADORecordSet.</p>
\r
748 <p><b>0.91 21 Dec 2000</b></p>
\r
749 <p>Fixed ODBC so ErrorMsg() is working.</p>
\r
750 <p>Worked around ADO unrecognised null (0x1) value problem in COM.</p>
\r
751 <p>Added Sybase support for FetchField() type</p>
\r
752 <p>Removed debugging code and unneeded html from various files</p>
\r
753 <p>Changed to javadoc style comments to adodb.inc.php.</p>
\r
754 <p>Added maxsql as synonym for mysqlt</p>
\r
755 <p>Now ODBC downloads first 8K of blob by default
\r
756 <p><b>0.90 15 Nov 2000</b></p>
\r
757 <p>Lots of testing of Microsoft ADO. Should be more stable now.</p>
\r
758 <p>Added $ADODB_COUNTREC. Set to false for high speed selects.</p>
\r
759 <p>Added Sybase support. Contributed by Toni Tunkkari (toni.tunkkari#finebyte.com). Bug in Sybase
\r
760 API: GetFields is unable to determine date types.</p>
\r
761 <p>Changed behaviour of RecordSet.GetMenu() to support size parameter (listbox) properly.</p>
\r
762 <p>Added emptyDate and emptyTimeStamp to RecordSet class that defines how to represent
\r
764 <p>Added MetaColumns($table) that returns an array of ADOFieldObject's listing
\r
765 the columns of a table.</p>
\r
766 <p>Added transaction support for PostgresSQL -- thanks to "Eric G. Werk" egw#netguide.dk.</p>
\r
767 <p>Added adodb-session.php for session support.</p>
\r
768 <p><b>0.80 30 Nov 2000</b></p>
\r
769 <p>Added support for charSet for interbase. Implemented MetaTables for most databases.
\r
770 PostgreSQL more extensively tested.</p>
\r
771 <p><b>0.71 22 Nov 2000</b></p>
\r
772 <p>Switched from using require_once to include/include_once for backward compatability with PHP 4.02 and earlier.</p>
\r
773 <p><b>0.70 15 Nov 2000</b></p>
\r
774 <p>Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP,
\r
775 except in Oracle 7 driver due to a bug in php_oracle.dll.</p>
\r
776 <p>PostgreSQL database driver contributed by Alberto Cerezal (acerezalp#dbnet.es).
\r
778 <p>Oci8 driver for Oracle 8 contributed by George Fourlanos (fou#infomap.gr).</p>
\r
779 <p>Added <i>mysqlt</i> database driver to support MySQL 3.23 which has transaction
\r
781 <p>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.</p>
\r
782 <p>Error message checking is now included in test suite.</p>
\r
783 <p>MoveNext() did not check EOF properly -- fixed.</p>
\r
784 <p><b>0.60 Nov 8 2000</b></p>
\r
785 <p>Fixed some constructor bugs in ODBC and ADO. Added ErrorNo function to ADOConnection
\r
787 <p><b>0.51 Oct 18 2000</b></p>
\r
788 <p>Fixed some interbase bugs.</p>
\r
789 <p><b>0.50 Oct 16 2000</b></p>
\r
790 <p>Interbase commit/rollback changed to be compatible with PHP 4.03. </p>
\r
791 <p>CommitTrans( ) will now return true if transactions not supported. </p>
\r
792 <p>Conversely RollbackTrans( ) will return false if transactions not supported.
\r
794 <p><b>0.46 Oct 12</b></p>
\r
795 Many Oracle compatibility issues fixed.
\r
796 <p><b>0.40 Sept 26</b></p>
\r
797 <p>Many bug fixes</p>
\r
798 <p>Now Code for BeginTrans, CommitTrans and RollbackTrans is working. So is the Affected_Rows
\r
799 and Insert_ID. Added above functions to test.php.</p>
\r
800 <p>ADO type handling was busted in 0.30. Fixed.</p>
\r
801 <p>Generalised Move( ) so it works will all databases, including ODBC.</p>
\r
802 <p><b>0.30 Sept 18</b></p>
\r
803 <p>Renamed ADOLoadDB to ADOLoadCode. This is clearer.</p>
\r
804 <p>Added BeginTrans, CommitTrans and RollbackTrans functions.</p>
\r
805 <p>Added Affected_Rows() and Insert_ID(), _affectedrows() and _insertID(), ListTables(),
\r
806 ListDatabases(), ListColumns().</p>
\r
807 <p>Need to add New_ID() and hasInsertID and hasAffectedRows, autoCommit </p>
\r
808 <p><b>0.20 Sept 12</b></p>
\r
809 <p>Added support for Microsoft's ADO.</p>
\r
810 <p>Added new field to ADORecordSet -- canSeek</p>
\r
811 <p>Added new parameter to _fetch($ignore_fields = false). Setting to true will
\r
812 not update fields array for faster performance.</p>
\r
813 <p>Added new field to ADORecordSet/ADOConnection -- dataProvider to indicate whether
\r
814 a class is derived from odbc or ado.</p>
\r
815 <p>Changed class ODBCFieldObject to ADOFieldObject -- not documented currently.</p>
\r
816 <p>Added benchmark.php and testdatabases.inc.php to the test suite.</p>
\r
817 <p>Added to ADORecordSet FastForward( ) for future high speed scrolling. Not documented.</p>
\r
818 <p>Realised that ADO's Move( ) uses relative positioning. ADOdb uses absolute.
\r
820 <p><b>0.10 Sept 9 2000</b></p>
\r
821 <p>First release</p>
\r
projects / SourceForge / phpwiki.git / blob