#87 open
Kris Jordan

Update uses new values in the Where selection

Reported by Kris Jordan | April 9th, 2009 @ 11:01 AM | in 0.30

Luiz: i have a A_x_B_x_C model where A, B and C are PKs 2 points here: 1. Recess doent allows me declare "!Column PrimaryKey" to A_id, B_id, C_id at the same time Sent at 10:14 AM on Thursday Luiz: 2. If i try to update an instance of A_x_B_x_C the update query is wrong, because it uses the NEW values int the WHERE clause Look: $abc->a_id = 1; $abc->b_id = 2; $abc->c_id = 3; $abc->exists(); $abc->a_id = 5; $abc->save(); what i expected: UPDATE A_x_B_C SET a_id = 5 WHERE a_id = 1 AND b_id = 1 AND c_id = 2; what i got: UPDATE A_x_B_C SET a_id = 5 WHERE a_id = 5 AND b_id = 1 AND c_id = 2; i think we need store key values in a private var on model object named like: $originalValues; and use the $originalValues for WHERE clause do you agree?

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

The Recess PHP Framework is an open source, full stack, RESTful PHP framework.


People watching this ticket