Hi,
I am new to CakePHP but worked extensively in C++/C/Java etc. I already
spend more than a day but could not figure out what is the reason for the
following problem.
I am using latest XAMP version with 5.4.16 PHP, Apache 2.4.4. We have
developed a small client on CakePHP with MYSQL DB. Its working fine. We
already has similar DB in MSSQL. Now we need to run this client with MSSQL.
We are using php_pdo_sqlsrv_54_ts.dll and php_sqlsrv_54_ts.dll for MSSQL
driver for this.
Whenever we are updating values in tables, we are using following
UpdateAll() of Model.PHP which further calls update() of datasource as
$this->Configurationtable->updateAll(('Configurationtable.configuration_optionsetting'
=> $limit ), array('Configurationtable.configuration_optionname =' =>
$optionName)))
Where $limit and $optionName has value values. This work work in MYSQL and
generates
UPDATE `dbname`.`configurationtable` AS `Configurationtable` SET
`Configurationtable`.`configuration_optionsetting` = 12 WHERE
`Configurationtable`.`configuration_optionname` = 'searchPaginationLimit'
But in MSSQL, it fails and generate something completely different like this
SELECT [Configurationtable].[id] AS [Configurationtable__id] FROM
[configurationtable] AS [Configurationtable] WHERE
[Configurationtable].[configuration_optionname] = N'searchPaginationLimit'
Now, if I modify the update() function in
\Cake\Model\Datasource\Database\Sqlserver.php and make it similar to
update() function in \Cake\Model\Datasource\Database\Mysql.php, then it
works absolutely fine and generate a proper "Update" Query in MSSQL also?
I could not figure out WHY? Is it something I am doing wrong OR is there a
bug in Cake?
Can you please help me.
Cheers
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
