Not equal to query

Rails
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 B. 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 S.

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 S. wrote:

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 S.

4

Hemant B. 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 S.

5

On Tue, Dec 29, 2009 at 2:27 AM, Hemant B.
[email protected]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” ]

Try the following:

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

or

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

-Conrad

“Bangalore” })

“Ruby on Rails: Talk” group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected][email protected]
.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–

You received this message because you are subscribed to the Google
Groups “Ruby on Rails: Talk” group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

6

Thanks Dude …
Worked …

Brijesh S. wrote:

Hemant B. 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 S.

7

Thanks conrad,

2nd worked … :slight_smile:

Conrad T. wrote:

On Tue, Dec 29, 2009 at 2:27 AM, Hemant B.
[email protected]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” ]

Try the following:

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

or

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

-Conrad