# How do I limit/restrict a results set?

**URL:** <https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729>\
**Category:** Rails\
**Created:** [November 12, 2006, 9:12pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729 "2006-11-12T21:12:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nfwt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2bfe46/32.png) [@nfwt](https://www.ruby-forum.com/u/nfwt)\
**Post date:** [November 12, 2006, 9:12pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729/1 "2006-11-12T21:12:59Z")

</div>

Simple question. I’m a newbie with rails and just need to restrict the  
results of a query (a where clause in SQL). I am building a simple  
application that enables the user to add pages and post comments to each  
page. I have build a table for pages and posts and have related the two  
models (one page to many posts). When a user is on a page, I just want  
the list of posts to be restricted to the posts made for that particular  
page. Here is what it would look like in SQL:

select \* from posts where posts.pageid = {this.pageid}

What should the syntax look like? Where would I restrict the results (in  
the controller or the model)?

Thanks.

---

<div class="post-metadata">

**Author:** ![nfwt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2bfe46/32.png) [@nfwt](https://www.ruby-forum.com/u/nfwt)\
**Post date:** [November 12, 2006, 9:25pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729/2 "2006-11-12T21:25:09Z")

</div>

you mean using

LIMIT 10 OFFSET 20 in sql

or

:limit =\> 10 in .find ?

---

<div class="post-metadata">

**Author:** ![nfwt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2bfe46/32.png) [@nfwt](https://www.ruby-forum.com/u/nfwt)\
**Post date:** [November 12, 2006, 9:29pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729/3 "2006-11-12T21:29:07Z")

</div>

Thanks for replying. Limit was probably a poor choice of words. The SQL  
equivalent of what I’m referring to is the WHERE clause.

select \* from posts where posts.pageid = {this.pageid}

---

<div class="post-metadata">

**Author:** ![nfwt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2bfe46/32.png) [@nfwt](https://www.ruby-forum.com/u/nfwt)\
**Post date:** [November 12, 2006, 10:09pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729/4 "2006-11-12T22:09:39Z")

</div>

Worked! Thx.

---

<div class="post-metadata">

**Author:** ![nfwt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2bfe46/32.png) [@nfwt](https://www.ruby-forum.com/u/nfwt)\
**Post date:** [November 12, 2006, 10:01pm UTC](https://www.ruby-forum.com/t/how-do-i-limit-restrict-a-results-set/75729/5 "2006-11-12T22:01:16Z")

</div>

so you want maybe:

:conditions =\> [“posts.pageid = ?”, this.pageid]