| Age | Commit message (Collapse) | Author | Files | Lines |
|
* quote fieldnames in _adodb_getupdatesql, fix indentations
* Fix my own conflict edits
Co-authored-by: Mark Newnham <mark@newnhams.com>
|
|
|
|
|
|
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.
|
|
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>
|
|
# Conflicts:
# adodb-lib.inc.php
|
|
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().
|
|
- Whitespace
- Coding guidelines
- Remove unused variables
- Remove empty if statements
- Optimization
|
|
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
|
|
|
|
Slightly more efficient code and removes PHPStorm warning about
uninitialized variable.
|
|
|
|
|
|
|
|
# Conflicts:
# adodb-lib.inc.php
# adodb-time.inc.php
|
|
|
|
Methods getMenu and getMenu3 throw E_NOTICE errors when ADODB_FETCH_MODE = ADODB_FETCH_ASSOC See #460. This enhancement adds support for this feature.
|
|
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.
|
|
Code missing from the _adodb_getupdatesql() method, added
|
|
# Conflicts:
# adodb-time.inc.php
# docs/changelog.md
# drivers/adodb-mssql.inc.php
# drivers/adodb-mssqlnative.inc.php
# drivers/adodb-oci8po.inc.php
|
|
|
|
|
|
|
|
SQL Server requires an alias when creating a count statement.
This true for Native Mode(mssqlnative), mssql and PDO drivers
|
|
SQL Server requires an alias when creating a count statement.
This true for Native Mode(mssqlnative), mssql and PDO drivers
|
|
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
Conflicts:
docs/changelog.md
|
|
|
|
|
|
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>
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|