Changeset fec9f11 in github

Timestamp:

Jun 4, 2012 4:13:42 AM (12 months ago)

Author:

Aleksander Machniak <alec@…>

Branches:

release-0.8

Children:

9c8ff86

Parents:

9ad0810

git-author:

Aleksander Machniak <alec@…> (06/04/12 04:11:24)

git-committer:

Aleksander Machniak <alec@…> (06/04/12 04:13:42)

Message:

Modify CONCAT() arguments, because + operator requires them to be of type varchar (#1488505)
With SQL Server 2012 we can use just CONCAT(), but we need to support older versions

Files:

• CHANGELOG (modified) (1 diff)
• program/include/rcube_mdb2.php (modified) (1 diff)

CHANGELOG

@@ -2 +2 @@
 ===========================
 
+- Fix SQL query for contacts listing on MS SQL Server (#1488505)
 - Update to TinyMCE 3.5.2
 - Fix window.resize handler on IE8 and Opera (#1488453)

program/include/rcube_mdb2.php

@@ -649 +649 @@
             case 'sqlsrv':
                 $delim = ' + ';
+                // Modify arguments, because + operator requires them to be of type varchar (#1488505)
+                // with SQL Server 2012 we can use just CONCAT(), but we need to support older versions
+                foreach ($args as $idx => $arg) {
+                    $args[$idx] = "CAST($arg AS varchar)";
+                }
                 break;
             default: