adodb-news — Subscribe for latest news on ADOdb

[ADOdb-news] ADOdb 5.20.5 released

[ADOdb N. <ado...@li...>]

ADOdb 5.20.5 was released on 10-Aug-2016


Download from Sourceforge
https://sourceforge.net/projects/adodb/files/latest/download

Web site and documentation
http://adodb.org/

Please report issues on GitHub
https://github.com/ADOdb/ADOdb/issues


Change Log
----------

- adodb: Fix fatal error when connecting with missing extension. #254
- adodb: Fix _adodb_getcount(). #236
- mssql: Destructor fails if recordset already closed. #268
- mssql: Use SQL server native data types if available. #234
- mysqli: Fix PHP notice in _close() method. #240
- pdo: Let driver handle SelectDB() and SQLDate() calls. #242
- xml: Fix PHP strict warning. #260
- xml: remove calls to 'unset($this)' (PHP 7.1 compatibility). #257

[ADOdb-news] ADOdb 5.20.0 released

[ADOdb N. <ado...@li...>]

ADOdb 5.20.0 was released on 28-Nov-2015


Download from Sourceforge
https://sourceforge.net/projects/adodb/files/latest/download

Web site and documentation
http://adodb.sourceforge.net/

Please report bugs on Github
https://github.com/ADOdb/ADOdb/issues


Change Log
----------

- adodb: Fix regression introduced in v5.19, causing queries to return 
empty rows. See Github #20, #93, #95
- adodb: Fix regression introduced in v5.19 in GetAssoc() with 
ADODB_FETCH_ASSOC mode and '0' as data. See Github #102
- adodb: AutoExecute correctly handles empty result set in case of 
updates. See Github #13
- adodb: Fix regex in Version(). See Github #16
- adodb: Align method signatures to definition in parent class 
ADODB_DataDict. See Github #31
- adodb: Improve compatibility of ADORecordSet_empty, thanks to Sjan 
Evardsson. See Github #43
- adodb: fix ADODB_Session::open() failing after successful 
ADONewConnection() call, thanks to Sjan Evardsson. See Github #44
- adodb: Only include memcache library once for PHPUnit 4.x, thanks to 
Alan Farquharson. See Github #74
- adodb: Move() returns false when given row is < 0, thanks to Mike Benoit.
- adodb: Add support for pagination with complex queries, thanks to Mike 
Benoit. See Github #88
- adodb: Parse port out of hostname if specified in connection 
parameters, thanks to Andy Theuninck. See Github #63
- adodb: Fix inability to set values from 0 to null (and vice versa) 
with Active Record, thanks to Louis Johnson. See Github #71
- adodb: Fix PHP strict warning in ADODB_Active_Record::Reload(), thanks 
to Boštjan Žokš. See Github #75
- adodb: Add mssql's DATETIME2 type to ADOConnection::MetaType(), thanks 
to MarcelTO. See Github #80
- adodb: When flushing cache, initialize it if it is not set, thanks to 
Paul Haggart. See Github #57
- adodb: Define DB_AUTOQUERY_* constants in main include file. See 
Github #49
- adodb: Improve documentation of fetch mode and assoc case
- adodb: Improve logic to build the assoc case bind array
- adodb: Strict-standards compliance for function names. See Github #18, 
#142
- adodb: Remove old PHP 4.x constructors for compatibility with PHP 7. 
See Github #139
- adodb: Initialize charset in ADOConnection::SetCharSet. See Github #39
- adodb: Fix incorrect handling of input array in Execute(). See Github #146
- adodb: Release Recordset when raising exception. See Github #143
- adodb: Added new setConnectionParameter() method, currently 
implemented in mssqlnative driver only. See Github #158.
- adodb-lib: Optimize query pagination, thanks to Mike Benoit. See 
Github #110
- memcache: use include_once() to avoid issues with PHPUnit. See 
http://phplens.com/lens/lensforum/msgs.php?id=19489
- mssql_n: Allow use of prepared statements with driver. See Github #22
- mssqlnative: Use ADOConnection::outp instead of error_log. See Github #12
- mssqlnative: fix failure on Insert_ID() if the insert statement 
contains a semicolon in a value string, thanks to sketule. See Github #96
- mssqlnative: Fix "invalid parameter was passed to sqlsrv_configure" 
error, thanks to Ray Morris. See Github #103
- mssqlnative: Fix insert_ID() failing if server returns more than 1 
row, thanks to gitjti. See Github #41
- mysql: prevent race conditions when creating/dropping sequences, 
thanks to MikeB. See Github #28
- mysql: Fix adodb_strip_order_by() bug causing SQL error for subqueries 
with order/limit clause, thanks to MikeB.
- mysql: workaround for HHVM behavior, thanks to Mike Benoit.
- mysqli: Fix qstr() when called without an active connection. See 
Github #11
- oci8: Fix broken quoting of table name in AddColumnSQL and 
AlterColumnSQL, thanks to Andreas Fernandez. see Github #67
- oci8: Allow oci8 driver to use lowercase field names in assoc mode. 
See Github #21
- oci8po: Prevent replacement of '?' within strings, thanks to Mark 
Newnham. See Github #132
- pdo: Added missing property (fixes PHP notices). see Github #56
- pdo: Align method signatures with parent class, thanks to Andy 
Theuninck. see Github #62
- pdo: new sqlsrv driver, thanks to MarcelTO. See Github #81
- pdo/mysql: New methods to make the driver behave more like 
mysql/mysqli, thanks to Andy Theuninck. see Github #40
- postgres: Stop using legacy function aliases
- postgres: Fix AlterColumnSQL when updating multiple columns, thanks to 
Jouni Ahto. See Github #72
- postgres: Fix support for HHVM 3.6, thanks to Mike Benoit. See Github #87
- postgres: Noblob optimization, thanks to Mike Benoit. See Github #112
- postgres7: fix system warning in MetaColumns() with schema. See 
http://phplens.com/lens/lensforum/msgs.php?id=19481
- sqlite3: ServerInfo() now returns driver's version
- sqlite3: Fix wrong connection parameter in _connect(), thanks to 
diogotoscano. See Github #51
- sqlite3: Fix FetchField, thanks to diogotoscano. See Github #53
- sqlite3: Fix result-less SQL statements executed twice. See Github #99
- sqlite3: use -1 for _numOfRows. See Github #151
- xmlschema: Fix ExtractSchema() when given $prefix and $stripprefix 
parameters, thanks to peterdd. See Github #92
- Convert languages files to UTF-8, thanks to Marc-Etienne Vargenau. See 
Github #32.

[ADOdb-news] Fwd: ADOdb 5.19 released

[News on A. t. P. db a. l. <ado...@li...>]

ADOdb 5.19 was released on 23-Apr-2014


Download from Sourceforge
https://sourceforge.net/projects/adodb/files/latest/download

Web site and documentation
http://adodb.sourceforge.net/

Please report bugs on Github
https://github.com/ADOdb/ADOdb/issues


Change Log
----------

* adodb: GetRowAssoc will return null as required. See
http://phplens.com/lens/lensforum/msgs.php?id=19289
* adodb: Fix GetRowAssoc bug introduced in 5.17, causing function to
return data from previous fetch for NULL fields. See
http://phplens.com/lens/lensforum/msgs.php?id=17539
* adodb: GetAssoc will return a zero-based array when 2nd column is
null. See https://sourceforge.net/p/adodb/bugs/130/
* adodb: Execute no longer ignores single parameters evaluating to
false. See https://sourceforge.net/p/adodb/patches/32/
* adodb: Fix LIMIT 1 clause in subquery gets stripped off. See
http://phplens.com/lens/lensforum/msgs.php?id=17813
* adodb-lib: Fix columns quoting bug. See
https://sourceforge.net/p/adodb/bugs/127/
* Added new ADODB_ASSOC_CASE_* constants. Thx to Damien Regad.
* sessions: changed lob handling to detect all variations of oci8 driver.
* ads: clear fields before fetching. See
http://phplens.com/lens/lensforum/msgs.php?id=17539
* mssqlnative: fixed many FetchField compat issues. See
http://phplens.com/lens/lensforum/msgs.php?id=18464. Also date format
changed to remove timezone.
* mssqlnative: Numerous fixes and improvements by Mark Newnham
     * Driver supports SQL Server 2005, 2008 and 2012
     * Bigint data types mapped to I8 instead of I
     * Reintroduced MetaColumns function
     * On SQL Server 2012, makes use of new CREATE SEQUENCE statement
     * FetchField caches metadata at initialization to improve performance
     * etc.
* mssqlnative: Fix Insert ID on prepared statement, thanks to Mike
Parks. See http://phplens.com/lens/lensforum/msgs.php?id=19079
* mssql: timestamp format changed to 'Y-m-d\TH:i:s' (ISO 8601) to make
them independent from DATEFORMAT setting, as recommended on [Microsoft
TechNet](http://technet.microsoft.com/en-us/library/ms180878%28v=sql.105%29.aspx#StringLiteralDateandTimeFormats)
* mysql/mysqli: Fix ability for MetaTables to filter by table name,
broken since 5.15. See http://phplens.com/lens/lensforum/msgs.php?id=19359
* odbc: Fixed MetaTables and MetaPrimaryKeys definitions in odbc driver
to match adoconnection class.
* odbc: clear fields before fetching. See
http://phplens.com/lens/lensforum/msgs.php?id=17539
* oci8: GetRowAssoc now works in ADODB_FETCH_ASSOC fetch mode
* oci8: MetaType and MetaForeignKeys argument count are now
strict-standards compliant
* oci8: Added trailing ';' on trigger creation for sequence fields,
prevents occurence of ORA-24344
* oci8quercus: new oci8 driver with support for quercus jdbc data types.
* pdo: Fixed concat recursion bug in 5.3. See
http://phplens.com/lens/lensforum/msgs.php?id=19285
* pgsql: Default driver (postgres/pgsql) is now postgres8
* pgsql: Fix output of BLOB (bytea) columns with PostgreSQL >= 9.0
* pgsql: Fix handling of DEFAULT NULL columns in AlterColumnSQL
* pgsql: Fix mapping of error message to ADOdb error codes
* pgsql: Reset parameter number in Param() method when $name == false
* postgres8: New class/type with correct behavior for _insertid(). See
Github #8
* postgres9: Fixed assoc problem. See
http://phplens.com/lens/lensforum/msgs.php?id=19296
* sybase: Removed redundant sybase_connect() call in _connect(). See
Github #3
* sybase: Allow connection on custom port. See Github #9
* sybase: Fix null values returned with ASSOC fetch mode. See Github #10
* Added Composer support. See Github #7

[ADOdb-news] ADOdb 5.19 released

[Damien R. <dr...@ma...>]

ADOdb 5.19 was released on 23-Apr-2014

Please report bugs at https://github.com/ADOdb/ADOdb/issues


Change Log
----------

* adodb: GetRowAssoc will return null as required. See 
http://phplens.com/lens/lensforum/msgs.php?id=19289
* adodb: Fix GetRowAssoc bug introduced in 5.17, causing function to 
return data from previous fetch for NULL fields. See 
http://phplens.com/lens/lensforum/msgs.php?id=17539
* adodb: GetAssoc will return a zero-based array when 2nd column is 
null. See https://sourceforge.net/p/adodb/bugs/130/
* adodb: Execute no longer ignores single parameters evaluating to 
false. See https://sourceforge.net/p/adodb/patches/32/
* adodb: Fix LIMIT 1 clause in subquery gets stripped off. See 
http://phplens.com/lens/lensforum/msgs.php?id=17813
* adodb-lib: Fix columns quoting bug. See 
https://sourceforge.net/p/adodb/bugs/127/
* Added new ADODB_ASSOC_CASE_* constants. Thx to Damien Regad.
* sessions: changed lob handling to detect all variations of oci8 driver.
* ads: clear fields before fetching. See 
http://phplens.com/lens/lensforum/msgs.php?id=17539
* mssqlnative: fixed many FetchField compat issues. See 
http://phplens.com/lens/lensforum/msgs.php?id=18464. Also date format 
changed to remove timezone.
* mssqlnative: Numerous fixes and improvements by Mark Newnham
     * Driver supports SQL Server 2005, 2008 and 2012
     * Bigint data types mapped to I8 instead of I
     * Reintroduced MetaColumns function
     * On SQL Server 2012, makes use of new CREATE SEQUENCE statement
     * FetchField caches metadata at initialization to improve performance
     * etc.
* mssqlnative: Fix Insert ID on prepared statement, thanks to Mike 
Parks. See http://phplens.com/lens/lensforum/msgs.php?id=19079
* mssql: timestamp format changed to 'Y-m-d\TH:i:s' (ISO 8601) to make 
them independent from DATEFORMAT setting, as recommended on [Microsoft 
TechNet](http://technet.microsoft.com/en-us/library/ms180878%28v=sql.105%29.aspx#StringLiteralDateandTimeFormats)
* mysql/mysqli: Fix ability for MetaTables to filter by table name, 
broken since 5.15. See http://phplens.com/lens/lensforum/msgs.php?id=19359
* odbc: Fixed MetaTables and MetaPrimaryKeys definitions in odbc driver 
to match adoconnection class.
* odbc: clear fields before fetching. See 
http://phplens.com/lens/lensforum/msgs.php?id=17539
* oci8: GetRowAssoc now works in ADODB_FETCH_ASSOC fetch mode
* oci8: MetaType and MetaForeignKeys argument count are now 
strict-standards compliant
* oci8: Added trailing ';' on trigger creation for sequence fields, 
prevents occurence of ORA-24344
* oci8quercus: new oci8 driver with support for quercus jdbc data types.
* pdo: Fixed concat recursion bug in 5.3. See 
http://phplens.com/lens/lensforum/msgs.php?id=19285
* pgsql: Default driver (postgres/pgsql) is now postgres8
* pgsql: Fix output of BLOB (bytea) columns with PostgreSQL >= 9.0
* pgsql: Fix handling of DEFAULT NULL columns in AlterColumnSQL
* pgsql: Fix mapping of error message to ADOdb error codes
* pgsql: Reset parameter number in Param() method when $name == false
* postgres8: New class/type with correct behavior for _insertid(). See 
Github #8
* postgres9: Fixed assoc problem. See 
http://phplens.com/lens/lensforum/msgs.php?id=19296
* sybase: Removed redundant sybase_connect() call in _connect(). See 
Github #3
* sybase: Allow connection on custom port. See Github #9
* sybase: Fix null values returned with ASSOC fetch mode. See Github #10
* Added Composer support. See Github #7

[ADOdb-news] ADOdb 4.52 released

[John L. <jo...@na...>]

Download:
http://sourceforge.net/project/showfiles.php?group_id=42718

FEATURES
=======

1) New $ADODB_FORCE_TYPE support in GetUpdateSQL/GetInsertSQL. Thx to Niko.

The behaviour of GetUpdateSQL() and GetInsertSQL() when converting empty
or null PHP variables to SQL is
controlled by the global $ADODB_FORCE_TYPE variable. Set it to one of the
values below. Default is
ADODB_FORCE_VALUE (3):

0 = ignore empty fields. All empty fields in array are ignored.
1 = force null. All empty, php null and string 'null' fields are changed
to sql NULL values.
2 = force empty. All empty, php null and string 'null' fields are changed
to sql empty '' or 0 values.
3 = force value. Value is left as it is. Php null and string 'null' are
set to sql NULL values and
empty fields '' are set to empty '' sql values.

define('ADODB_FORCE_IGNORE',0);
define('ADODB_FORCE_NULL',1);
define('ADODB_FORCE_EMPTY',2);
define('ADODB_FORCE_VALUE',3);



2) Bug fixes in Replace(). Thx to Alex.


3) Added ADODB_ASSOC_CASE support to postgres/postgres7 driver.


4) Support for DECLARE in oci8.



Changes
=======
Bug found in Replace() when performance logging enabled, introduced in
ADOdb 4.50. Fixed.

Replace() checks update stmt. If update stmt fails, we now return
immediately. Thx to alex.

Added support for $ADODB_FORCE_TYPE in GetUpdateSQL/GetInsertSQL. Thx to
niko.

Added ADODB_ASSOC_CASE support to postgres/postgres7 driver.

Support for DECLARE in oci8.

[ADOdb-news] ADOdb 4.51 released

[John L. <jo...@na...>]

Download: http://sourceforge.net/project/showfiles.php?group_id=42718

- New DSN support. This means you can connect using:

   $dsn =
"$driver://$user:$pwd@$host/$database?$opt1=$val1&$opt2=$val2";
   $db = NewADOConnection($dsn);
   # no $db->Connect( ) required.

For more info, see:
http://phplens.com/adodb/code.initialization.html#dsnsupport

- Updated to new version of adodb-xmlschema.

- Many improvements to mysql, mssql, oci8, postgresql, db2 drivers.

- Fixes to GetUpdateSQL() for ADODB_FORCE_NULLS problems,  and "order by"
is now ignored in SQL.

- PHP5 compatability fixes: M'soft ADO variant dates work now.

- Lastly, a warning: PHP 5.0.0's oci8 support is not stable. Let's hope
5.0.1 is better.


Changes:
4.51 29 July 2004

Added adodb-xmlschema 1.0.2. Thx dan and richard.

Added new adorecordset_ext_* classes. If ADOdb extension installed for
mysql, mysqlt and oci8 (but not oci8po), we use the superfast ADOdb
extension code for movenext.

Added schema support to mssql and odbc_mssql MetaPrimaryKeys().

Patched MSSQL driver to support PHP NULL and Boolean values while binding
the input array parameters in the _query() function. By Stephen Farmer.

Added support for clob's for mssql, UpdateBlob(). Thx to gfran#directa.com.br

Added normalize support for postgresql (true=lowercase table name, or
false=case-sensitive table names) to MetaColumns($table, $normalize=true).

PHP5 variant dates in ADO not working. Fixed in adodb-ado.inc.php.

Constant ADODB_FORCE_NULLS was not working properly for many releases (for
GetUpdateSQL). Fixed. Also GetUpdateSQL strips off ORDER BY now - thx
Elieser Leão.

Perf Monitor for oci8 now dynamically highlights optimizer_* params if too
high/low.

Added dsn support to NewADOConnection/ADONewConnection.

Fixed out of page bounds bug in _adodb_pageexecute_all_rows() Thx to
"Sergio Strampelli" sergio#rir.it

Speedup of movenext for mysql and oci8 drivers.

Moved debugging code _adodb_debug_execute() to adodb-lib.inc.php.

Fixed postgresql bytea detection bug. See
http://phplens.com/lens/lensforum/msgs.php?id=9849.

Fixed ibase datetimestamp typo in PHP5. Thx stefan.

Removed whitespace at end of odbtp drivers.

Added db2 metaprimarykeys fix.

Optimizations to MoveNext() for mysql and oci8. Misc speedups to Get*
functions.