I'm having issues getting checkboxes to update a cross-reference table correctly. I keep seeing entries in the locations_users table, for location_id and user_id, "11" and "2", respectively. The user id is fine, but there is no such location with id 11. There are only 5 locations and their ids go from 1-5! I can't seem to find where the 11 is coming from.
This is in the view: <% Location.find(:all).each do |location| %> <input type="checkbox" name="user[locations_ids]" value="<%= location.id %>" <% if @user.locations.include?(location) %> checked="checked" <% end %> /> <%= location.name %> <% end %> This is in the controller: [code=]def edit @user = User.find(params[:id]) @locations = Location.find(:all) @locationsusers = LocationsUser.new end
def update @user = User.find(params[:id]) @locations = Location.find(:all) @locations.each do |location| @locationsids = location.id end @locationsusers = LocationsUser.new(params[:locations_users]) @locationsusers.user_id = @user.id @locationsusers.location_id = @locationsids.id if @locationsusers.update_attributes(params[:locations_users]) flash[:notice] = 'User was successfully updated.' redirect_to :action => 'list' else render :action => 'edit' end end Have a look at the relevant parts of the output and notice how the line...
"SELECT * FROM locations INNER JOIN locations_users ON locations.id = locations_users.location_id WHERE (locations_users.user_id = 2 )"
is not repeated in the 'update' action:
Processing UserController#edit Parameters: {"action"=>"edit", "id"=>"2", "controller"=>"user"} User Columns (0.001195) SHOW FIELDS FROM users User Load (0.000083) SELECT * FROM users WHERE (users.`id` = 2) LocationsUser Columns (0.000656) SHOW FIELDS FROM locations_users Location Load (0.000129) SELECT * FROM locations Rendering within layouts/user Rendering user/edit Location Load (0.000114) SELECT * FROM locations Location Columns (0.000900) SHOW FIELDS FROM locations Join Table Columns (0.000558) SHOW FIELDS FROM locations_users Location Load (0.000327) SELECT * FROM locations INNER JOIN locations_users ON locations.id = locations_users.location_id WHERE (locations_users.user_id = 2 )
Processing UserController#update Parameters: {"user"=>{"locations_ids"=>["1", "3"]}, "commit"=>"Save Data", "action"=>"updateLocation", "id"=>"2", "controller"=>"user"} User Columns (0.001231) SHOW FIELDS FROM users User Load (0.000087) SELECT * FROM users WHERE (users.`id` = 2) Location Load (0.000133) SELECT * FROM locations Location Columns (0.000906) SHOW FIELDS FROM locations LocationsUser Columns (0.000687) SHOW FIELDS FROM locations_users SQL (0.000068) BEGIN SQL (0.000209) INSERT INTO locations_users (`location_id`, `user_id`) VALUES(11, 2) SQL (0.004631) COMMIT