• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1261
  • Last Modified:

RoR Find using Conditions, or find_by_sql?

Hi, im trying to query my database and am passing a type variable with value "Hardware", a manufacturer variable with value of "Dell and an invoice variable with value of "SI11244"

Here is the url im putting into my browser:

i have a findbyparams method in my controller but have no idea how to put these values into a find statement to return the aassets where the TYPE column equals "Hardware, the MANUFACTURER column equals "Dell" and INVOICE column equals "SI11244"

1 Solution

def find
  @type = params[:type]
  @manuf = params[:manufacturer]
  @invoice = params[:invoice]
  @assets = Asset.find_all_by_type_and_manufacturer_and_invoice(@type, @manuf, @invoice)
  @assets = Asset.find(:all, :conditions => ["type = ? and manufacturer = 
? and invoice = ?", @type, @manuf, @invoice])
# both should return the same thing

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now