rails activerecord multiple query

Question

Thanks for your time !

It's a simple question but I've searched for some time and still cannot get the function suit me.

I get a table named *lr_transaction_tables* in DB and a class LrTransactionsTable < ActiveRecord::Base with it.

I can @entry_ary = LrTransactionsTable.find(:all) to fetch the whole table and present it in the view by :

<table id="trans-war-table">
  <% @entry_ary.each do |item| %>
      <tr>
        <td><%= item.ltname %></td>
        <td><%= item.name %></td>
      </tr>
  <% end %>
</table>

But how do I get the data where the data under ltname column is "specific word" instead of all of it.

I've tried @entry_ary = LrTransactionsTable.find_by_ltname( "specific word" ), but it give me the error that undefined methodeach' for nil:NilClass`

ltname and name is the column name in the table.

Salil · Accepted Answer · 2012-10-29 10:17:41Z

2

For Rails 2

LrTransactionsTable.find(:all, :conditions => {:ltname => "specific word"})

For Rails 3

@entry_ary = LrTransactionsTable.where(ltname: "specific word")

OR

@entry_ary = LrTransactionsTable.where(["ltname =? ", "specific word"])

answered Oct 29, 2012 at 10:17

Salil

47.7k22 gold badges127 silver badges161 bronze badges

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

2 Comments

simonmenke Over a year ago

the :conditions => { ... } syntax is deprecated.

Salil Over a year ago

@simonmenke:- Yes, i know.He's not specify the version of the ruby he's using so gave example of both.Thanks anyway.

microcosme · Accepted Answer · 2012-10-29 10:20:10Z

1

I'll use the where method to set a condition:

LrTransactionsTable.where(:ltname => "specific word")

answered Oct 29, 2012 at 10:20

microcosme

7031 gold badge5 silver badges22 bronze badges

Comments

Dipak Panchal · Accepted Answer · 2012-10-29 10:21:10Z

1

try best way, always right query in model

in your controller

LrTransactionsTable.find_ltname("specific word")

and write in your model

def find_ltname(name)
  where("ltname = ?", name)
end

or you can also create a scope for that

scope :find_ltname, lambda{|name|{ :conditions => ["ltname = ?", name]}

answered Oct 29, 2012 at 10:21

Dipak Panchal

6,0344 gold badges34 silver badges69 bronze badges

Comments

simonmenke · Accepted Answer · 2012-10-29 10:18:13Z

0

try this:

@entry_ary = LrTransactionsTable.where(ltname: "specific word")

answered Oct 29, 2012 at 10:18

simonmenke

2,92021 silver badges29 bronze badges

Collectives™ on Stack Overflow

rails activerecord multiple query

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related