From 59945678393b591e263cdee90a8e278a723f93df Mon Sep 17 00:00:00 2001 From: Xavier Noria Date: Wed, 14 Jul 2010 13:17:01 +0200 Subject: AR queying guide: let limit and offset be different numbers to help making clear what is what in the explanation, rewords also a bit --- railties/guides/source/active_record_querying.textile | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'railties/guides/source') diff --git a/railties/guides/source/active_record_querying.textile b/railties/guides/source/active_record_querying.textile index 2e23604838..5c4ed3a803 100644 --- a/railties/guides/source/active_record_querying.textile +++ b/railties/guides/source/active_record_querying.textile @@ -447,28 +447,28 @@ h4. Limit and Offset To apply +LIMIT+ to the SQL fired by the +Model.find+, you can specify the +LIMIT+ using +limit+ and +offset+ methods on the relation. -You can use +limit+ to specify the number of records to be retrieved, and use +offset+ to specify the number of records to skip before starting to return the records. For example: +You can use +limit+ to specify the number of records to be retrieved, and use +offset+ to specify the number of records to skip before starting to return the records. For example Client.limit(5) -This code will return a maximum of 5 clients and because it specifies no offset it will return the first 5 clients in the table. The SQL it executes will look like this: +will return a maximum of 5 clients and because it specifies no offset it will return the first 5 in the table. The SQL it executes looks like this: SELECT * FROM clients LIMIT 5 -Or chaining both +limit+ and +offset+: +Adding +offset+ to that -Client.limit(5).offset(5) +Client.limit(5).offset(30) -This code will return a maximum of 5 clients beginning with the 6th client in the clients table, skipping the first five clients as specified by the offset. The SQL looks like: +will return instead a maximum of 5 clients beginning with the 31st. The SQL looks like: -SELECT * FROM clients LIMIT 5, 5 +SELECT * FROM clients LIMIT 5, 30 h4. Group -- cgit v1.2.3