Need help with controller/show.html.erb

Hello,

I am attempting to display data in the requseraccount form, from the
divisions table.

For example: I have a division_id field in requseraccount that works
great. No issues getting this populated from my create form. The
problem is that I don’t want to display the id when showing the form.
I want to display the division_name, which is in the division table.

Here is a copy of my code
requseraccounts_controller.rb and schema.rb: http://dpaste.com/35716/
requseraccoutns: show.html.erb: http://dpaste.com/35717/
SQL Query: http://dpaste.com/35725/

I get the following error when I try the above code:

ActiveRecord::RecordNotFound in RequseraccountsController#show

Couldn’t find Division with ID=8

Which makes sense, since it is trying to do a query WHERE
division_id=8. I need the query to use requseaccount.divisions_id
(which is 2) and not requseraccount.id (which is 8).

Any advice would be much appreciated.

Michael

Hi Michael

You have to specify the association between division and requseraccount
models

In your models directory:

division.rb

class Division < ActiveRecord::Base
has_many :requseraccount
end

class Requseraccount < ActiveRecord::Base
belongs_to :division
end

And now you can do the following in your controller and view:

@req = Requseraccount.find(:all, :include => :division)
@req.division.name # “division_name”

You can read more about it at http://guides.rubyonrails.org/. And about
associations in http://guides.rubyonrails.org/association_basics.html

Regards

Michael R wrote:

Hello,

I am attempting to display data in the requseraccount form, from the
divisions table.

For example: I have a division_id field in requseraccount that works
great. No issues getting this populated from my create form. The
problem is that I don’t want to display the id when showing the form.
I want to display the division_name, which is in the division table.

Here is a copy of my code
requseraccounts_controller.rb and schema.rb: http://dpaste.com/35716/
requseraccoutns: show.html.erb: http://dpaste.com/35717/
SQL Query: http://dpaste.com/35725/

I get the following error when I try the above code:

ActiveRecord::RecordNotFound in RequseraccountsController#show

Couldn’t find Division with ID=8

Which makes sense, since it is trying to do a query WHERE
division_id=8. I need the query to use requseaccount.divisions_id
(which is 2) and not requseraccount.id (which is 8).

Any advice would be much appreciated.

Michael

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs