I seemed to have gotten it working, not sure what I did though -_-
On Jan 11, 1:59 pm, nurvzy <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
