Find with AND : Search « ActiveRecord « Ruby

1.	ActiveRecord
2.	Array
3.	CGI
4.	Class
5.	Collections
6.	Database
7.	Date
8.	Design Patterns
9.	Development
10.	File Directory
11.	GUI
12.	Hash
13.	Language Basics
14.	Method
15.	Network
16.	Number
17.	Rails
18.	Range
19.	Reflection
20.	Statement
21.	String
22.	Threads
23.	Time
24.	Tk
25.	Unit Test
26.	Windows Platform
27.	XML

Ruby » ActiveRecord » Search

Find with AND









Account.find :all, :conditions => { :first_name =>  @first_name,

                                    :last_name => @last_name,

                                    :favorite_band_id => nil }



which would result in the following SQL query:



SELECT *

  FROM accounts

  WHERE

    first_name = 'John'

    AND last_name = 'Doe'

    AND favorite_band_id IS NULL

Related examples in the same category

1.	Find by column name
2.	Find by conditions
3.	id is default for find(1)
4.	A find_or_create_by_* dynamic finder
5.	Find many values
6.	Find first or find all
7.	Find with conditions
8.	Find with OR

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.