Retrive data from table


#1

hi…

how can I retrive data from a specific row of table by giving two
or more properties of that row?
examlpe I want to get data which ID = 23 and NAME = “xx” like

thankx


#2

xxmithila wrote:

hi…

how can I retrive data from a specific row of table by giving two
or more properties of that row?
examlpe I want to get data which ID = 23 and NAME = “xx” like

As long as your table is made up of Models, you can do something like:

@mydata = ModelName.find(‘23’, :conditions => “NAME = ‘xxx’” )

HTH

Matt


#3

Hi,

xxmithila wrote:

how can I retrive data from a specific row of table
by giving two or more properties of that row?
examlpe I want to get data which
ID = 23 and NAME = “xx” like

If you know the ID, you don’t need anything else. IDs are unique so
the
query on the second field just eats cycles with no upside. Assuming
this
was just a poorly thought-out example…

two or more properties are queried, in the most general case, with:
Model.find(all, :conditions => ["first_condition =? && second_condition

?", first_param, second_param])

Use the find_by helpers for more readable / idiomatic code.

HTH,
Bill


#4

On Sat, Nov 1, 2008 at 6:36 AM, mithila karunarathna
removed_email_address@domain.invalidwrote:

by giving two or more properties of that row?

"

thankx friends I got the answer…
thankx again


#5

On Fri, Oct 31, 2008 at 8:42 AM, Bill W.
removed_email_address@domain.invalidwrote:

If you know the ID, you don’t need anything else. IDs are unique so the
Bill

hoooo

@mydata = ModelName.find(‘23’, :conditions => “NAME = ‘xxx’” )
but this command return error
"

You have a nil object when you didn’t expect it!
You might have expected an instance of Array.
The error occurred while evaluating nil.each

"
I know that code is correct but it return error. What is the reson for
this?
xxmithila