How can I update a record to include the current date?
I tried:
$this->Order->id = $orderID;
$this->Order->save(array('done_date' => 'CURDATE()')
However, CakePHP adds single quotes to CURDATE like so:
UPDATE `orders` SET `phase1_complete` = 'CURDATE()' WHERE
`order_id` = '6'
The above SQL is wrong because the single quotes around CURDATE()
prevents the query from working.
I read a baker blog at that said to use "-!", but that didn't help
either.
http://cakebaker.42dh.com/2007/05/04/how-to-use-sql-functions-in-conditions/#comments
Any ideas on how I can use the MySQL CURDATE() within CakePHP?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
