#6510: Model->updateAll not adding single quotes when DB data type is "date"
----------------------------------------------------------+-----------------
Reporter: cstea | Type: Bug
Status: new | Priority:
Medium
Milestone: 1.2.x.x | Component:
Model
Version: 1.2 Final | Severity:
Normal
Keywords: model, date, mysql, query, single, quotes | Php_version: PHP
5
Cake_version: 1.2.3.8166 |
----------------------------------------------------------+-----------------
When using the $model->updateAll and setting a value for a date field:
array('last_updated'=> date('Y-m-d'))
the SQL generated is
UPDATE table SET last_updated = 2009-07-15
The date value is not wrapped inside of single quotes. This in effect does
not save the value properly in MySQL
--
Ticket URL: <https://trac.cakephp.org/ticket/6510>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
