# Why find\_by\_sql works and find(args) doesn't

**URL:** <https://www.ruby-forum.com/t/why-find-by-sql-works-and-find-args-doesnt/150488>\
**Category:** Rails\
**Created:** [October 9, 2008, 3:01am UTC](https://www.ruby-forum.com/t/why-find-by-sql-works-and-find-args-doesnt/150488 "2008-10-09T03:01:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jicksta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/7ba0ec/32.png) [@jicksta](https://www.ruby-forum.com/u/jicksta)\
**Post date:** [October 9, 2008, 3:01am UTC](https://www.ruby-forum.com/t/why-find-by-sql-works-and-find-args-doesnt/150488/1 "2008-10-09T03:01:29Z")

</div>

I’m trying to use Campsite.find(:all, :condition =\> [‘walk\_id =  
?’,params[:walks][:id]]) but fails and instead, if I use  
Campsite.find\_by\_sql("select \* from campsites where walk\_id =  
"+params[:walks][:id]), it works fine. So, I’m wondering why…  
I’ve created combo box as:  
\<%form\_tag do%\>  
\<%=select :walks, :id, @great\_walks%\>  
\<%end%\>

thanks.

---

<div class="post-metadata">

**Author:** ![jicksta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/7ba0ec/32.png) [@jicksta](https://www.ruby-forum.com/u/jicksta)\
**Post date:** [October 9, 2008, 3:48am UTC](https://www.ruby-forum.com/t/why-find-by-sql-works-and-find-args-doesnt/150488/2 "2008-10-09T03:48:29Z")

</div>

It’s “conditions”, not “condition”:

Campsite.find(:all, :conditions =\> [‘walk\_id = ?’,params[:walks][:id]])

On Wed, Oct 8, 2008 at 10:01 PM, Jay P.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> ## thanks.
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> >

–  
Maurício Linhares  
[http://alinhavado.wordpress.com/](http://alinhavado.wordpress.com/) (pt-br) | [http://blog.codevader.com/](http://blog.codevader.com/)  
(en)  
João Pessoa, PB, +55 83 8867-7208