diff options
Diffstat (limited to 'railties/guides/source')
-rw-r--r-- | railties/guides/source/active_record_querying.textile | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/railties/guides/source/active_record_querying.textile b/railties/guides/source/active_record_querying.textile index 7d4d4083fd..5da15bbb5c 100644 --- a/railties/guides/source/active_record_querying.textile +++ b/railties/guides/source/active_record_querying.textile @@ -223,7 +223,7 @@ This makes for clearer readability if you have a large number of variable condit h5. Range conditions -If you're looking for a range inside of a table (for example, users created in a certain timeframe) you can use the conditions option coupled with the IN sql statement for this. If you had two dates coming in from a controller you could do something like this to look for a range: +If you're looking for a range inside of a table (for example, users created in a certain timeframe) you can use the conditions option coupled with the +IN+ SQL statement for this. If you had two dates coming in from a controller you could do something like this to look for a range: <ruby> Client.all(:conditions => ["created_at IN (?)", @@ -308,7 +308,7 @@ The good thing about this is that we can pass in a range for our fields without Client.all(:conditions => { :created_at => (Time.now.midnight - 1.day)..Time.now.midnight}) </ruby> -This will find all clients created yesterday by using a BETWEEN sql statement: +This will find all clients created yesterday by using a +BETWEEN+ SQL statement: <sql> SELECT * FROM clients WHERE (clients.created_at BETWEEN '2008-12-21 00:00:00' AND '2008-12-22 00:00:00') |