summaryrefslogtreecommitdiff
path: root/adodb-lib.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2021-03-08Bump version to 5.21.1-devDamien Regad1-1/+1
2021-02-27Bump version to 5.21.0v5.21.0Damien Regad1-1/+1
2021-02-02Bump version to 5.21.0-rc.1v5.21.0-rc.1Damien Regad1-1/+1
2021-01-25Remove all magic quotes related codeDamien Regad1-18/+15
The $magic_quote parameter for public methods was kept for backwards compatibility purposes, but is no longer used. Fixes #674
2020-12-20Bump version to 5.21.0-beta.1v5.21.0-beta.1Damien Regad1-1/+1
2020-12-06Removed references to phplens.com, see #564Mark Newnham1-2/+2
2020-01-08fix #572, also quote fieldnames when value set null, fix indentations (#585)peterdd1-122/+124
* quote fieldnames in _adodb_getupdatesql, fix indentations * Fix my own conflict edits Co-authored-by: Mark Newnham <mark@newnhams.com>
2020-01-05Replace call to _array_change_key_case see #587Mark Newnham1-16/+4
2020-01-04function makes needless PHP4 version Check, see #583Mark Newnham1-3/+3
2019-12-30Support for T-SQL-styled square BracketsMarat1-0/+4
Microsoft wraps column names in square brackets in T-SQL statements, which is not really obligatory but becomes necessary when reserved keywords are used as columns names (e.g. 'BEGIN' or 'CURRENT'). Fixes #246 Signed-off-by: Damien Regad <dregad@mantisbt.org> Original commits from PR squashed and message reworded.
2019-11-28adodb_strip_order_by() strips incorrectly if there are multiple order by ↵Mark Newnham1-1/+7
statements #549 If the SQL statement passed to adodb_strip_order contains multiple order by statements, the incorrect one is stripped. This change ensures that only the last one is stripped Co-Authored-By: mustafa-soner-acar <mustafa-soner-acar@users.noreply.github.com>
2019-11-24Merge branch 'hotfix/5.20'Damien Regad1-120/+116
# Conflicts: # adodb-lib.inc.php
2019-11-24Reduce code duplication in _adodb_getmenu functionsDamien Regad1-81/+80
Create 2 new internal functions - _adodb_getmenu_select() to print the SELECT tag, and - _adodb_getmenu_option() to print the OPTION tags and call them from _adodb_getmenu() / _adodb_getmenu_gp().
2019-11-24Code cleanup for _adodb_getmenu()/_adodb_getmenu_gp()Damien Regad1-71/+69
- Whitespace - Coding guidelines - Remove unused variables - Remove empty if statements - Optimization
2019-11-24Fix getMenu() for ADODB_FETCH_BOTHDamien Regad1-15/+21
Commit 61c5a8cf0ea9df2777eed7d1bb7935593aa93545 (see #460) introduced a regression in the behavior of getMenu() when ADODB_FETCH_MODE is set to ADODB_FETCH_BOTH, causing it to use the recordset's first column for both the select options' value and description. Fixes #482
2019-11-23Whitespace / commentsDamien Regad1-9/+4
2019-11-23Avoid if statement within foreach loopDamien Regad1-24/+17
Slightly more efficient code and removes PHPStorm warning about uninitialized variable.
2019-11-23Fix indentationDamien Regad1-68/+68
2019-11-12Codespell assisted typo cleaningJean-Michel Vourgère1-1/+1
2019-01-06Bump version to 5.20.14v5.20.14Damien Regad1-1/+1
2019-01-03Merge branch 'hotfix/5.20'Damien Regad1-38/+43
# Conflicts: # adodb-lib.inc.php # adodb-time.inc.php
2019-01-03WhitespaceDamien Regad1-38/+37
2019-01-01Add support for ADODB_FETCH_ASSOC to getMenu()Mark Newnham1-35/+39
Methods getMenu and getMenu3 throw E_NOTICE errors when ADODB_FETCH_MODE = ADODB_FETCH_ASSOC See #460. This enhancement adds support for this feature.
2019-01-01Fix support for getMenu with ADODB_FETCH_ASSOCMark Newnham1-34/+39
The getMenu and getMenu3 methods generate E_NOTICE errors when ADODB_FETCH_MODE is set to ADODB_FETCH_ASSOC See #460. This changes adds support for that.
2018-08-09constant ADODB_FORCE_NULL_AND_ZERO not honoured, see #447Mark Newnham1-0/+14
Code missing from the _adodb_getupdatesql() method, added
2018-08-06Merge branch 'hotfix/5.20' (v5.20.13)Damien Regad1-1/+1
# Conflicts: # adodb-time.inc.php # docs/changelog.md # drivers/adodb-mssql.inc.php # drivers/adodb-mssqlnative.inc.php # drivers/adodb-oci8po.inc.php
2018-08-06Reset version to avoid merge conflictsDamien Regad1-1/+1
2018-08-06Bump version to 5.20.13v5.20.13Damien Regad1-1/+1
2018-08-06Fix Sourceforge tracker linksDamien Regad1-1/+1
2018-08-05_adodb_getcount was not SQL Server Compliant See #423Mark Newnham1-8/+10
SQL Server requires an alias when creating a count statement. This true for Native Mode(mssqlnative), mssql and PDO drivers
2018-08-05_adodb_getcount was not SQL Server Compliant See #423Mark Newnham1-8/+10
SQL Server requires an alias when creating a count statement. This true for Native Mode(mssqlnative), mssql and PDO drivers
2018-07-23Table/Column names quoted in replace functionmarvinwaterman1-7/+14
2018-03-30Bump version to 5.20.12v5.20.12Damien Regad1-1/+1
2018-03-30Bump version to 5.20.11v5.20.11Damien Regad1-1/+1
2018-03-08Bump version to 5.20.10v5.20.10Damien Regad1-1/+1
2017-11-25Merge branch 'hotfix/5.20.10'Damien Regad1-1/+4
2017-11-25MSSQL requires table alias in _adodb_getcount() queryZoltan Monori1-1/+4
Currently the _ADODB_ALIAS_ is only used for postgres and mysql, but it's also necessary for mssql, otherwise the query assigned to $rewritesql on line 422 fails and produces the following warning: PHP Warning (2): mssql_query(): message: Incorrect syntax near ')'. (severity 15) in /usr/share/php/adodb/drivers/adodb-mssql.inc.php on line 832 Fixes #359 Signed-off-by: Damien Regad <dregad@mantisbt.org> Original commit amended to split long line.
2016-12-21Bump version to 5.20.9v5.20.9Damien Regad1-1/+1
2016-12-17Bump version to 5.20.8v5.20.8Damien Regad1-1/+1
2016-10-11Remove references to ADOdb ExtensionDamien Regad1-13/+6
The ADOdb Extension's development stopped at version 5.04. It is no longer maintained or supported, yet the library still contains code referencing it. If those code branches are executed, ADOdb will not perform properly, due to missing constant declarations (among other things). This commit removes all references to the Extension. Fixes #270, #269
2016-09-20Bump version to 5.20.7v5.20.7Damien Regad1-1/+1
2016-09-20Update changelogDamien Regad1-1/+1
2016-08-31Bump version to 5.20.6v5.20.6Damien Regad1-1/+1
2016-08-11Merge branch 'hotfix/5.20.5'Damien Regad1-1/+1
Conflicts: docs/changelog.md
2016-08-11Reset version to avoid merge conflictsDamien Regad1-1/+1
2016-08-10Bump version to 5.20.5v5.20.5Damien Regad1-1/+1
2016-05-25Fix _adodb_getcount()mike.benoit1-1/+1
This reverts the regular expression back to its original (i.e. before it was changed in #88, see commit 41839f5c18abe262ee088f1d4bd92453616d2a4a) as it seems to work in more cases, and doesn't break simple ones. Since we support _ADODB_COUNT now anyways we should be able to handle any possible situation. Fixes #236, #239 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2016-03-30Bump version to 5.20.4Damien Regad1-1/+1
2016-03-25Enhancement to getInsertSQL() value defaultingMark Newnham1-4/+19
This enhancement provides an additional method of defaulting values in getInsertSql(): ADODB_FORCE_NULL_AND_ZERO. It allows getInsertSql to default columns that have a number type to zero instead of null when a field is not provided to the insert statement. This feature is especially useful for financial applications, when math may involve the addition of columns, some of which may be null. Fixes #214
2016-01-02Update version 5.21.0-dev release year to 2016Damien Regad1-1/+1