Not equal to query

rubyonrails-talk
1

Hi Champs,

Hanging out with a problem.. I can find out the name of cities with City.find(:all).. I can find out the Bangalore city with City.find_by_name("Bangalore"). But what query i have to write to find the name of all cities except "Bangalore" ?

I tried this but of no use .. City.find(:all, :conditions => { :name != "Bangalore" })

Can you people push me into the right direction.

- Cheers

2

Hemant Bhargava wrote:

Hi Champs,

Hanging out with a problem.. I can find out the name of cities with City.find(:all).. I can find out the Bangalore city with City.find_by_name("Bangalore"). But what query i have to write to find the name of all cities except "Bangalore" ?

I tried this but of no use .. City.find(:all, :conditions => { :name != "Bangalore" })

Can you people push me into the right direction.

- Cheers

Try below syntax.

City.find(:all, :conditions => [ "name != 'Bangalore'"] )

Thanks Brijesh Shah

3

I am having Bangalore in an variable. I mean lets suppose selected_city. Then i tried this:- City.find(:all, :conditions => [ "name != selected_city" ]

Nopes this is not working ..

Brijesh Shah wrote:

4

Hemant Bhargava wrote:

I am having Bangalore in an variable. I mean lets suppose selected_city. Then i tried this:- City.find(:all, :conditions => [ "name != selected_city" ]

Nopes this is not working ..

Then try with this...

City.find(:all, :conditions => [ "name != ?",selected_city ]

selected_city must be variable.

Thanks Brijesh Shah

5

I am having Bangalore in an variable. I mean lets suppose selected_city.

Then i tried this:-

City.find(:all, :conditions => [ “name != selected_city” ]

Try the following:

City.find( :all, :conditions => [ “name != selected_city” ] )

or

City.find(:all, :conditions => [ “name != ?”, selected_city ] )

-Conrad

6

Thanks Dude .. Worked ..

Brijesh Shah wrote:

7

Thanks conrad,

2nd worked .. :slight_smile:

Conrad Taylor wrote: