Hi, I have a table of venues, with each venue belonging to an area and a type. I recently dropped the table and added to it some addressline fields. I have re-migrated it but now the area_id field saves as a random? 9 figure number. Both the area_id and venuetype_id integers are created in the same way from the create new form and the venuetype_id saves as normal but not the area_id. Can anyone offer any help?
whats shown in the console
=> [#<Venue id: 4, name: "sdf", addressline1: "", addressline2: "", addressline3
: "", addressline4: "", icontoppx: 234, iconleftpx: 234, area_id: 946717224, ven
uetype_id: 8, created_at: "2011-03-17", updated_at: "2011-03-17 23:33:53">]
irb(main):030:0>
the area_id should be 8 in the above example.
The area and venuetype id's are slected from dropdown boxes on the new venue form.
new form
<%= form_for @venue do |f| %>
<p>name: <br>
<%= f.text_field :name %></p>
<p>top: <br>
<%= f.text_field :icontoppx %></p>
<p>left: <br>
<%= f.text_field :iconleftpx %></p>
<p>addressline1: <br>
<%= f.text_field :addressline1 %></p>
<p>addressline2: <br>
<%= f.text_field :addressline2 %></p>
<p>addressline3: <br>
<%= f.text_field :addressline3 %></p>
<p>addressline4: <br>
<%= f.text_field :addressline4 %></p>
<p>area: <br>
<%= f.collection_select(:area_id, Area.all, :id, :name) %></p>
<p>venuetype: <br>
<%= f.collection_select(:venuetype_id, Venuetype.all, :id, :name) %></p>
<br><br>
<div class="button"><%= submit_tag %></div>
<% end %>
Areas table
class CreateAreas < ActiveRecord::Migration
def self.up
create_table :areas do |t|
t.string :name
t.timestamps
end
end
def self.down
drop_table :areas
end
end
Thanks very much for any help!