summaryrefslogtreecommitdiff
path: root/drivers/adodb-mssqlnative.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2023-03-12Remove deprecated $databaseName propertyDamien Regad1-1/+0
ADOConnection::$databaseName was marked as obsolete in ADOdb 4.66. Since the assignment that was kept for backwards-compatibility in the ADOConnection::selectDB() method is causing deprecation warnings with PHP 8.2, now is the time to get rid of it. The 2018 rewrite of DB2 driver introduced a private $databaseName property; this has been removed in favor of ADOConnection::$database. Fixes #932, #904 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2022-10-28affected_rows() returns false when called incorrectlyMark Newnham1-3/+5
If called incorrectly, the affected_rows() method now returns false instead of returning an error from the SQL server driver. Fixes #895
2022-09-03Remove uneeded call to ADOconnection::out for debuggingMark Newnham1-7/+0
2022-08-26mssql: insert_id returns false if value is out of rangeMark Newnham1-1/+1
Insert_id() attempts to force the return value to an integer data type which fails if the value is out of range. Fixes #853
2022-05-09mssql: Fix undefined variable when closing connectionDamien Regad1-4/+8
Also remove redundant assignment of $this->_connectionID, which is already set to false in ADOConnection::close(). Fixes #835
2022-05-06mssql: fix undeclared variableMark Newnham1-0/+2
Prevents occurrence of PHP notice: Automatic conversion of false to array is deprecated in PHP 8.1 Fixes #829 (cherry picked from commit 40c3ed6d12354f7a83d40cd18f7bc4983dbbd33b)
2021-11-07Uniformize metaForeignKeys() function signatureDamien Regad1-1/+1
- public visibility - camelCase - change $owner default from false to '' - add $associative param where missing - PHPDoc updates
2021-11-07WhitespaceDamien Regad1-5/+5
2021-08-17Redo Merge tag 'v5.21.1'Damien Regad1-52/+57
# Conflicts: # adodb.inc.php # docs/changelog.md # drivers/adodb-mssqlnative.inc.php # drivers/adodb-mysqli.inc.php Fixes #751
2021-08-17Redo Merge branch 'hotfix/5.21' Standardized file headersDamien Regad1-20/+22
Try to do it right this time... # Conflicts: # adodb-memcache.lib.inc.php Fixes #751
2021-08-17Reset version to avoid merge conflictsDamien Regad1-1/+1
Fixes #751
2021-08-17Revert changes since Standardized file headers mergeDamien Regad1-79/+103
The conflicts resolution applied when merging the Standardized file headers (commit e9dcce3df24912ad869d0193f0b419f2309101fc) was seriously messed up, actually overwriting a number of changes in the master branch. Rather than trying to go and fix things one by one which has a high risk of messing things further, it's easier to redo the merge from a clean slate, so this commit reverts the following: - "Merge branch 'hotfix/5.21' Standardized file headers", e9dcce3df24912ad869d0193f0b419f2309101fc - "Merge tag 'v5.21.1'", 5f437df3104159d5d659f60e31bef8d33c34995f - "Reset version to 5.22.0-dev" af9234a525c3255af051a330164486d73be4c63a - "Fix incorrect resolution of merge conflicts" a6733f61b0165b366c8d2c70d9af82edc3881951. - "Fix syntax error in toexport.inc.php" 20b01e83cb61b6b2460f64c7d1277c5f4cc28574. Fixes #751
2021-08-15PHPDoc, code styleDamien Regad1-1/+1
2021-08-15Cache Field objects with Property instead of static varDamien Regad1-15/+10
Change the static array introduced in fieldTypesArray() (see #367) to a class variable ($fieldObjectsCache), so the cache now only lasts for the Recordset's lifetime. Since the mssqlnative was already using a private $fieldObjects property for the same purpose, the declaration was removed, and usages of the old name changed to match the one defined in the parent class. Fixes #687
2021-08-15Remove invalid assignment by referenceDamien Regad1-1/+1
2021-08-15Coding guidelinesDamien Regad1-38/+29
2021-08-15mssql: duplicate key in SQLDate convert formatsDamien Regad1-1/+1
"y/m/d" key was defined both as 102 (ANSI) and 111 (Japan) (see #307). Updating the array to match documentation for ANSI, i.e. "y.m.d" [[1]]. Fixes #748 [1]: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
2021-08-14Standard file header: /driversDamien Regad1-20/+22
2021-04-11mssql: enable InsertID capability by defaultDamien Regad1-4/+5
Fixes #692
2021-04-11Add loop to get the last resultDamien Regad1-2/+5
Server may return more than one row if triggers are involved (see #41).
2021-04-11mssql: enable _insertID() againDamien Regad1-25/+70
In ADOdb 5.21.0, for performance reasons [1] the _query() method no longer retrieves the last inserted Id. This introduced a regression, as it was only possible to retrieve the Insert Id for "normal" queries, but not parameterized ones as Insert_ID() always returned null in this case. To maintain the driver's performance, we now allow the client to decide whether insert queries should execute the extra SCOPE_IDENTITY() call, by providing a new enableLastInsertID() method. Fixes #692 [1]: https://github.com/ADOdb/ADOdb/issues/185#issuecomment-169057606
2021-03-11WhitespaceDamien Regad1-39/+35
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
2020-12-20Bump version to 5.21.0-beta.1v5.21.0-beta.1Damien Regad1-1/+1
2020-12-19adodb.org is now served over SSLDamien Regad1-1/+1
Change web site references from http://adodb.org to https.
2020-12-11@mnewnham Add support for specific SQL Server connection port. See #624 …Mark Newnham1-1/+8
Enhancement allows use of a specfic database connection port
2020-12-03PHP7.4 requires definition of variable see #637Mark Newnham1-2/+4
PHP7.4 requires definition of variable before accessing array offsets
2020-08-02Merge branch 'hotfix/5.20' (v5.20.18)Damien Regad1-5/+1
# Conflicts: # docs/changelog.md # drivers/adodb-mssqlnative.inc.php
2020-08-02Reset version to avoid merge conflictsDamien Regad1-1/+1
2020-06-28Bump Versionv5.20.18Mark Newnham1-1/+1
2020-05-31Retrieve error messages early before connection close #614Mark Newnham1-0/+6
Error messages from last error are lost if the connection is closed before retrieval
2020-05-31Retrieve error messages early before connection close #614Mark Newnham1-1/+13
Error messages from last error are lost if the connection is closed before retrieval
2020-03-31Bump version to 5.20.17v5.20.17Damien Regad1-1/+1
2020-03-30PHP7.4 throws error at uninitialized array, #608Mark Newnham1-1/+8
method Fields() accessed an unitialized array, that was not trapped in versions of PHP prior to 7.4. method now checks to see if array is initialized.
2020-03-30PHP7.4 throws error at uninitialized array, #608Mark Newnham1-1/+7
method Fields() accessed an unitialized array, that was not trapped in versions of PHP prior to 7.4. method now checks to see if array is initialized.
2020-01-24Remove PHP4 code checksMark Newnham1-135/+3
Driver incorrectly used mssql functionality, and has never been used with php4 anyway. Now reverts to parent method for unixdate/unixtime.
2020-01-24Remove unneeded PHP4 checksMark Newnham1-4/+6
2020-01-12Reset version to avoid merge conflictsDamien Regad1-1/+1
2020-01-12Bump version to 5.20.16v5.20.16Damien Regad1-1/+1
2020-01-08Connection is a resource, not an object, see #590Mark Newnham1-1/+1
2020-01-08Connection is a resource, not an object see #590Mark Newnham1-1/+1
2019-12-30mssql: MetaForeignKeys not returning all FK'sJean-Cyril Poiraud1-1/+5
MetaForeignKeys returns an associative array with the name of reference table for key. But when there are 2 foreign keys from the same reference table, MetaForeignKeys returns only the last foreign key. A solution is to merge arrays when there are several foreign keys. Fixes #486 Signed-off-by: Damien Regad <dregad@mantisbt.org> Original commits from PR squashed and message reworded.
2019-11-24mssqlnative: delegate _numOfFields init to _fetchFields()Damien Regad1-5/+1
The recent release of the PHP mssql native driver (5.6) has introduced an issue that causes ADODB/PHP to crash on any query that returns no fields/data. Until a fix is available, we remove the sqlsrv_field_metadata() call in _initrs() method, since the _numOfFields property is anyway initialized as part of _fetchFields() execution. Fixes #492
2019-11-24Bump version to 5.20.15v5.20.15Damien Regad1-1/+1
2019-11-12Codespell assisted typo cleaningJean-Michel Vourgère1-2/+2
2019-01-19Added support for metaProceduresMark Newnham1-0/+66
The metaProcedures method is now supported for the SQL Server native driver, and returns a list of stored procedures, functions and methods
2019-01-06Bump version to 5.20.14v5.20.14Damien Regad1-1/+1
2018-08-06Merge branch 'hotfix/5.20' (v5.20.13)Damien Regad1-2/+1
# Conflicts: # adodb-time.inc.php # docs/changelog.md # drivers/adodb-mssql.inc.php # drivers/adodb-mssqlnative.inc.php # drivers/adodb-oci8po.inc.php
generated by cgit v1.3 (git 2.53.0) at 2026-07-04 02:39:59 +0000