# find\_by\_sql

**URL:** <https://discuss.rubyonrails.org/t/find-by-sql/54222>\
**Category:** rubyonrails-talk\
**Created:** [September 8, 2010, 11:08am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222 "2010-09-08T11:08:49Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kannan](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@Kannan](https://discuss.rubyonrails.org/u/Kannan)\
**Post date:** [September 8, 2010, 11:08am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/1 "2010-09-08T11:08:49Z")

</div>

Hi,

I am using find\_by\_sql (“SELECT \* FROM taxas WHERE taxon\_id = ‘39’”) in controller.

Instead of ‘39’… I need to get variable from the user through view.rhtml.

Kindly help me on this scripting.

---

<div class="post-metadata">

**Author:** ![Amit2](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Amit2](https://discuss.rubyonrails.org/u/Amit2)\
**Post date:** [September 8, 2010, 11:11am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/2 "2010-09-08T11:11:57Z")

</div>

Hi,

You can pass the variable as params to your controller .

---

<div class="post-metadata">

**Author:** ![Frederick\_Cheung](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/frederick_cheung/32/3901_2.png) [@Frederick\_Cheung](https://discuss.rubyonrails.org/u/Frederick_Cheung)\
**Post date:** [September 8, 2010, 11:16am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/3 "2010-09-08T11:16:39Z")

</div>

> Hi,
> 
> I am using find\_by\_sql ("SELECT \* FROM taxas WHERE taxon\_id = '39'") in controller.
> 
> Instead of '39'... I need to get variable from the user through view.rhtml.

There's no reason to use find\_by\_sql here - a regular find with conditions or a dynamic finder (find\_by\_taxon\_id) should be fine.

Fred

---

<div class="post-metadata">

**Author:** ![Kannan](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@Kannan](https://discuss.rubyonrails.org/u/Kannan)\
**Post date:** [September 8, 2010, 11:40am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/4 "2010-09-08T11:40:51Z")

</div>

Hi Amit,

Thank you for reply, I dont know the method to apply params, kinldy give me some tutorial to apply params and modifications in controller, model and view for applying param. I am a new bee.

Hi Frederick,

Thank you for reply, when i use find\_by\_taxon\_id, I am unable to apply it directly with constant and i need to apply through param. I dnt know the method to apply param. If you know the method to apply param in this case kindly give me tutorial or reference which for modifications in controller, model and view. I am a new bee.

---

<div class="post-metadata">

**Author:** ![Amit2](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Amit2](https://discuss.rubyonrails.org/u/Amit2)\
**Post date:** [September 8, 2010, 11:44am UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/5 "2010-09-08T11:44:06Z")

</div>

Please got through this tutorial [http://www.tutorialspoint.com/ruby/index.htm](http://www.tutorialspoint.com/ruby/index.htm)

---

<div class="post-metadata">

**Author:** ![Kannan](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@Kannan](https://discuss.rubyonrails.org/u/Kannan)\
**Post date:** [September 8, 2010, 1:48pm UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/6 "2010-09-08T13:48:08Z")

</div>

Hi,

Thanks to both Amit and Frederick, It works…

---

<div class="post-metadata">

**Author:** ![Amit2](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Amit2](https://discuss.rubyonrails.org/u/Amit2)\
**Post date:** [September 8, 2010, 1:54pm UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/7 "2010-09-08T13:54:14Z")

</div>

Great!

---

<div class="post-metadata">

**Author:** ![radhames\_brito](https://avatars.discourse-cdn.com/v4/letter/r/8edcca/32.png) [@radhames\_brito](https://discuss.rubyonrails.org/u/radhames_brito)\
**Post date:** [September 8, 2010, 3:50pm UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/8 "2010-09-08T15:50:37Z")

</div>

one note never pass the params hash to a sql sentence NEVER.

---

<div class="post-metadata">

**Author:** ![Kannan](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@Kannan](https://discuss.rubyonrails.org/u/Kannan)\
**Post date:** [September 8, 2010, 4:39pm UTC](https://discuss.rubyonrails.org/t/find-by-sql/54222/9 "2010-09-08T16:39:19Z")

</div>

Hi brito,

I used “find” by the way mr.Frederick adviced. i never used params in sql sentence. thank you for your intimation.