Selecting From A Different Table

[Paul Thomas]

How do I select records from a table that has a different name than my
controller?

My example is as follows

in locations_controller.rb

class LocationsController < ApplicationController

def new
@location = Location.new
@regions = #Needs to do a findall) to populate from regions table
end

 

[James Edward Gray II]

How do I select records from a table that has a different name than my
controller?

My example is as follows

in locations_controller.rb

class LocationsController < ApplicationController

def new
@location = Location.new
@regions = #Needs to do a findall) to populate from regions table
end

I believe you are looking for:

@regions = Region.findall)

Assuming I guess your model name correctly. Just remember that find
() is just a method call on some model.

Hope that helps.

James Edward Gray II

 

[Paul Thomas]

I believe you are looking for:

@regions = Region.findall)

Assuming I guess your model name correctly. Just remember that find
() is just a method call on some model.

Hope that helps.

James Edward Gray II

Thanks for the prompt reply. When I call @regions = Region.findall)
the @regions is empty. Region is my model name as well.

Here are my models that are of importance to this.

class Region < ActiveRecord::Base
has_one :location
end

class Location < ActiveRecord::Base
belongs_to :region
end

And from the controller
def new
@location = Location.new
@regions = Region.findall) # @regions is still empty
end

And lastly, from the view (_form.rhtml -- used in edit.rhtml and
new.rhtml)
<% collection_select("location", "region_id", @regions, "id", "name") %>

 

[Wilson Bilkovich]

Try putting <%=3D debug(@regions) %> on your _form.rhtml, above the
collection_select call.
I believe you'll find that the regions are there, it's just that your
select call isn't quite right. (Should be <%=3D, not <%, by the way)

Try this:
def new
@location =3D Location.new
@regions =3D Region.findall)
@region_options =3D @regions.zip(@regions)
end

..and then, in the form:
<%=3D select('location', 'region_id', @region_options) %>

--Wilson.

 

[MrPaul]

Thank you. The root of my problem was the missing =.