diff options
| author | Andreas Scherer <andreas_coder@freenet.de> | 2009-02-19 18:42:41 +0100 |
|---|---|---|
| committer | Andreas Scherer <andreas_coder@freenet.de> | 2009-02-19 18:42:41 +0100 |
| commit | 07a1d645ee2218c4d57ff778f65899a8ac5d454e (patch) | |
| tree | cfd9cfc55078560b533c399c39a754a1921e800b /railties/guides/source/active_record_querying.textile | |
| parent | 1eee0d41f9bb6f3b912227db45abc9b52e60bc49 (diff) | |
| download | rails-07a1d645ee2218c4d57ff778f65899a8ac5d454e.tar.gz rails-07a1d645ee2218c4d57ff778f65899a8ac5d454e.tar.bz2 rails-07a1d645ee2218c4d57ff778f65899a8ac5d454e.zip | |
Consistent UPCASE setting of 'SQL'.
(Maybe one should use the <acronym> tag for acronyms and apply CSS
'text-transform: uppercase' globally. ;-)
Diffstat (limited to 'railties/guides/source/active_record_querying.textile')
| -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') |