Either SQL statement works for me directly typing it into an SQL query, Don't know why it's not working for you, what database are you using and what version? You might need to submit a bug report.
On Jan 9, 3:01 pm, Miles J <[email protected]> wrote: > My id is in the table and everything is correct, the problem is this: > > UPDATE `friends` SET `status` = 'blocked', `blockedTime` = 1231456514 > WHERE `friends`.`id` = 23 > > Should be this: > > UPDATE `friends` SET `friends`.`status` = 'blocked', > `friends`.`blockedTime` = 1231456514 > WHERE `friends`.`id` = 23 > > The extra `friends`. on the id is causing problems I believe. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
