From 07a1d645ee2218c4d57ff778f65899a8ac5d454e Mon Sep 17 00:00:00 2001 From: Andreas Scherer Date: Thu, 19 Feb 2009 18:42:41 +0100 Subject: Consistent UPCASE setting of 'SQL'. (Maybe one should use the tag for acronyms and apply CSS 'text-transform: uppercase' globally. ;-) --- railties/guides/source/active_record_querying.textile | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'railties') 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: 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}) -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: SELECT * FROM clients WHERE (clients.created_at BETWEEN '2008-12-21 00:00:00' AND '2008-12-22 00:00:00') -- cgit v1.2.3