summaryrefslogtreecommitdiff
path: root/drivers/adodb-mssqlnative.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2026-03-19Reverts commit error removing metaTablesSqlMark Newnham1-1/+2
2026-03-11mssql: fix regression retrieving affected_rows in SQL ServerMark Newnham1-0/+32
Retrieves affected rows before connection closed if necessary. Fixes #606, PR #1216
2026-02-18Adds refactored metaforeignkeys methodMark Newnham1-22/+85
2026-02-18Validates table name in MetaIndexes to allow for correct return valuesMark Newnham1-2/+28
2026-02-17Ensures the database names and fetch modes are reset after method callMark Newnham1-12/+32
2026-02-14Move the cachedSchemaFlush property from mssqlnative to coreMark Newnham1-1/+0
This prevents dynamic property warnings when a portable application is written that accesses the property from a non-mssqlnative driver
2026-02-06Adds the length functionMark Newnham1-0/+13
2025-09-29Drop Sequence references tables, not sequencesMark Newnham1-10/+72
Sequence methods return incorrect success values CreateSequence uses non-standard error handling GenID returns next id as string, not integer
2023-05-22Set $fetchMode property in ADORecordSet constructorDamien Regad1-14/+0
This reduces code duplication as the logic to initialize $fetchMode from $ADODB_FETCH_MODE global was repeated in most drivers. $adodbFetchMode is systematically initialized as well now; previously it was only set in those drivers having specific fetch modes. Fixes #958
2023-03-12Merge branch 'hotfix/5.22'Damien Regad1-1/+0
# Conflicts: # adodb.inc.php
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-28Merge branch 'hotfix/5.22'Damien Regad1-2/+4
# Conflicts: # drivers/adodb-mssqlnative.inc.php
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-06Merge tag 'v5.22.3'Damien Regad1-7/+0
ADOdb version 5.22.3 released 2022-09-06 # Conflicts: # adodb.inc.php # docs/changelog.md
2022-09-03Remove uneeded call to ADOconnection::out for debuggingMark Newnham1-7/+0
2022-08-26Merge branch 'hotfix/5.22'Damien Regad1-1/+1
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-10Merge branch 'hotfix/5.22'Damien Regad1-4/+8
# Conflicts: # adodb.inc.php # docs/changelog.md
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-06Fix whitespaceDamien Regad1-1/+1
2022-05-06Simplify ADODB_mssqlnative::serverInfo()Damien Regad1-21/+7
This is a follow-up on 94030fbcfcac1ae8c835dad70b13c127a3714427. As discussed in #830, it is no longer useful to save and restore the fetch mode, or to store the information in a static variable; this was necessary when a stored procedure was used to retrieve server info.
2022-05-06Merge branch 'hotfix/5.22'Damien Regad1-0/+2
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-09Merge branch 'master' of https://github.com/ADOdb/ADOdbMark Newnham1-6/+6
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-09-18Moved the class variables to the parent see #747Mark Newnham1-10/+1
The properties to be used as basis for re-factor of pgsql fetchfieldarray #687
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
generated by cgit v1.3 (git 2.53.0) at 2026-07-10 12:22:54 +0000