# Variable conditions in find queries

**URL:** <https://www.ruby-forum.com/t/variable-conditions-in-find-queries/107204>\
**Category:** Rails\
**Created:** [June 19, 2007, 5:47am UTC](https://www.ruby-forum.com/t/variable-conditions-in-find-queries/107204 "2007-06-19T05:47:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [June 19, 2007, 5:47am UTC](https://www.ruby-forum.com/t/variable-conditions-in-find-queries/107204/1 "2007-06-19T05:47:27Z")

</div>

What is the correct syntax for using variables in find conditions?

I tried this but it doesnt seem to work, I also couldnt find any  
documentation online

@vote = Vote.find(:all, :conditions =\> ‘user\_id = “@user.id”’, :order  
=\> “created\_at DESC”, :limit =\> “5” )

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [June 19, 2007, 12:10pm UTC](https://www.ruby-forum.com/t/variable-conditions-in-find-queries/107204/2 "2007-06-19T12:10:11Z")

</div>

@vote = Vote.find(:all,  
:conditions =\> ["user\_id = ? ", @user.id],  
:order =\> “created\_at DESC”,  
:limit =\> 5)

If you want to put more conditions:  
:conditions =\> ["user\_id = ? and group\_id = ? ", @user.id, @group.id]

ActiveRecord quotes(…security…) the condition for you

claudio

On Jun 19, 5:46 am, “removed\_email\_address@domain.invalid” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)