Rails 3: where query issue

Question

I am learning about 'where' in Rails 3 and I am wondering why my code is giving me a NoMethod Error.

  def create
    #get form values from 'new' page
    @post = Post.new(params[:post])

    #search for the inventory item with the sku code the user typed in the form
    @item = Inventory.where(:sku_code => @post.sku_code)

    #set post variable to a variable from the row with the sku code
    @post.detail = @item.detail

    @post.save
  end

By searching the SKU, I want to retrieve the other variables in the same id and set them to my @post variable. Anyone able to give me a hand?

Kulbir Saini · Accepted Answer · 2012-07-29 07:32:01Z

1

Assuming that SKU code is unique, you got to do it like this

@post = Post.new(params[:post])

@post.detail = Inventory.where(:sku_code => @post.sku_code).first.try(:detail)

first will fetch the first (and possibly only) record from the database. try will try to fetch detail if the returned Inventory was not nil.

Check this blog post to learn more about try method.

answered Jul 29, 2012 at 7:32

Kulbir Saini

3,9151 gold badge28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jbearden Over a year ago

Thanks for responding. I checked the references and they are correct. It is giving me a Template is missing error: Missing template posts/create, application/create. Any ideas?

iltempo Over a year ago

Usually you want to redirect after creation, for example to the show action. Or show the form again by rendering new if the post cannot be saved. See as well guides.rubyonrails.org/getting_started.html#creating-new-posts

Collectives™ on Stack Overflow

Rails 3: where query issue

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related