summaryrefslogtreecommitdiff
path: root/drivers
AgeCommit message (Collapse)AuthorFilesLines
2014-04-30Simplify SQL in postgres7 MetaForeignKeysDamien Regad1-41/+22
The original SQL from William Kolodny [William.Kolodny#gt-t.net] was very complex with multiple sub-select statements. Through use of regexp_replace() instead of split_part(), we now have only a single subquery. Removed obsolete comment.
2014-04-30Reformat SQL statementsDamien Regad1-81/+117
2014-04-30WhitespaceDamien Regad2-41/+41
2014-04-30Bump version to 5.20devDamien Regad56-56/+56
2014-04-23Bump version to 5.19v5.19Damien Regad56-56/+56
2014-04-22Sybase: fix null values returned with ASSOC fetch modeHadadi Péter1-1/+2
When selecting from a Sybase DB using ADODB_FETCH_ASSOC mode, all returned values will be NULL in the result set (fetch modes NUM and BOTH are ok). Fixes Github issue #10 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2014-04-22Sybase: allow connection on custom portHadadi Péter1-0/+12
Minor changes to original patch (Whitespace, use // for comments) Fixes Github issue #9 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2014-04-20Fix outdated references to readme.htmDamien Regad1-1/+1
2014-04-16Define postgres8 driver classDamien Regad2-23/+43
The _insertid() method introduced in postgres9 driver really belongs in postgres8, since OID field was actually removed in 8.1. This commit creates new postgres8 classes, moves the method from the '9' driver to the new ADODB_postgres8 class, and makes the '9' classes inherit from postgres8 instead of postgres7.
2014-04-16PHPdoc for _insertid() functionDamien Regad1-2/+10
2014-04-16Postgres: use lastval() to retrieve last insert idDamien Regad1-8/+3
Reverting change from d01454c0bf608ecd6625ccd9d968d45af7adac4c which introduced a regression. Fixes #8
2014-04-16postgres driver classes now use unified constructorDamien Regad3-25/+13
2014-04-16Whitespace and commentsDamien Regad1-7/+6
2014-03-18MSSQL: change timestamp format to ISO 8601Damien Regad3-3/+3
As recommended on Microsoft TechNet site http://technet.microsoft.com/en-us/library/ms180878%28v=sql.105%29.aspx#StringLiteralDateandTimeFormats
2014-03-04Fix Execute() ignoring param evaluating to falseDamien Regad1-1/+1
When ADOConnection->Execute is called with a single non-array parameter that evaluates to false, it ignores the parameter. Fixed by doing a strict-type comparison. Note that single boolean "false" parameter needs to be passed in as array(false). Reported by Alejandro Vásquez Fixes sourceforge patch #32
2014-02-24Fix ADODB_postgres64->Param()Damien Regad1-1/+6
The method now properly resets the parameter count to 1 when $name is false (or 0).
2014-02-24Remove closing php tagDamien Regad57-78/+0
http://php.net/manual/en/language.basic-syntax.phptags.php
2014-01-21mssqlnative: prepared statement now returns last Insert IDDamien Regad1-6/+21
Fixes Github issue #5, pull request #6
2014-01-21Bump version to 5.19devDamien Regad58-58/+58
Bumped 'dev' version allows users who rely on source code downloaded from the git repository rather than an official release tarball to reliably determine that they are running a development version of the library.
2014-01-21Ads driver: clear fields before fetchingDamien Regad1-15/+4
Ensures the fetched recordset does not contain any data left over from an earlier fetch operation. Same fix as a1e2d109b756d607fb258dcdc94aeb4a52e5b454
2014-01-21Odbc driver: MoveNext() now calls _fetch()Damien Regad1-12/+1
2014-01-21Odbc driver: clear fields before fetchingDamien Regad1-3/+3
Fix submitted by Warwick Smith in [1]. Ensures the fetched recordset does not contain any data left over from an earlier fetch operation. [1] http://phplens.com/lens/lensforum/msgs.php?id=17539
2014-01-14Whitespace and PHPDocDamien Regad1-289/+285
2014-01-14oci8 MetaType and MetaForeignKeys argument count are now strict-standards ↵Mark Newnham1-4/+21
compliant
2014-01-02MS SQL Native: Insert ID on prepared statement.Mike Parks1-6/+21
Implemented a fix (source: http://phplens.com/lens/lensforum/msgs.php?id=19079) that would address an issue where the last insert ID would not be returned when using a prepared statement.
2013-08-31Impossible to retrieve BLOB from DB with PostgreSQL >= 9.0Damien Regad1-0/+9
The new default 'hex' for bytea_output setting, causes PHP to incorrectly process the column's contents. As recommended in [1], we set bytea_output to 'escape' when connecting, to ensure this works Fixes #4 [1] https://bugs.php.net/bug.php?id=59831
2013-08-31Whitespace fixesDamien Regad1-100/+107
2013-08-28oci8->Execute: if $inputarr is scalar, make it an arrayDamien Regad1-2/+2
2013-08-23Removed redundant sybase_connect() call in _connect()Knut Behrends1-1/+0
Fixes #3
2013-08-23Fix whitespaceDamien Regad1-80/+82
2013-08-12mysql/mysqli: fix MetaTables filteringDamien Regad2-8/+38
The change in metaTablesSQL introduced in v5.15 broke the ability to filter tables using a mask. Thanks to Arnt Witteveen for reporting the issue [1] [1] http://phplens.com/lens/lensforum/msgs.php?id=19359
2013-08-09Whitespace fixesDamien Regad1-95/+95
2013-08-09Various MSSQL fixesMark Newnham1-75/+276
Contact the commit's author directly for all comments/fixes. General ======= - The driver is qualified to run on Server 2005, 2008 and 2012. - At startup, the driver identifies the SQL Server version, which allows it to invisibly take advantage of new features available in SQL server 2012. - It will not run on SQL Server 2000, although I'm sure it would be easy enough to fix. - It includes all patches to the known bugs that I can find on the phplens forum. - Much of the debugging has been removed, as this impeded program debugging when used with FastCGI - Some fixes are my own versions of those reported on the phplens boards drivers/adodb-mssqlnative.inc ============================= Changed mapping of bigint from I to I8 MetaColumns() -------------- Missing MetaColumns function, re-introduced, Produces an extended list of 10 field attributes, including auto-increment, nullable GenID() / CreateSequence() -------------------------- - On Server 2008 and lower, uses the historical sequence emulation. - On Server 2012. Uses the newly introduced Create Sequence statement. FetchField() ------------ This follows the method used in the oracle driver and caches the metadata at initialisation, which helps performance. datadict/datadict-mssqlnative.inc ================================= Missing file reintroduced, to support SQL Server format datadict functions perf/perf-mssqlnative.inc ========================= Tables() -------- Arguments to the Tables() function declared incorrectly
2013-08-05Reorg: ADOdb5 (master) branchDamien Regad58-0/+21216
- Move all files in adodb5/ to root - Remove adodb-for-php4/ directory