# Write insert query in views

**URL:** <https://www.ruby-forum.com/t/write-insert-query-in-views/116199>\
**Category:** Rails I18n\
**Created:** [October 3, 2007, 12:12pm UTC](https://www.ruby-forum.com/t/write-insert-query-in-views/116199 "2007-10-03T12:12:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhaval\_parikh33](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bcef8e/32.png) [@dhaval\_parikh33](https://www.ruby-forum.com/u/dhaval_parikh33)\
**Post date:** [October 3, 2007, 12:12pm UTC](https://www.ruby-forum.com/t/write-insert-query-in-views/116199/1 "2007-10-03T12:12:04Z")

</div>

Hello frnds

Is there any method to write the insert query in the .rhtml file (eg:  
-list.rhtml). If so please do let me know.

Thanks

Dhaval P.

---

<div class="post-metadata">

**Author:** ![dhaval\_parikh33](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bcef8e/32.png) [@dhaval\_parikh33](https://www.ruby-forum.com/u/dhaval_parikh33)\
**Post date:** [October 4, 2007, 8:05am UTC](https://www.ruby-forum.com/t/write-insert-query-in-views/116199/2 "2007-10-04T08:05:04Z")

</div>

You really, really, don’t want to do this.  
Fetching data directly from the views is bad, and storing data is  
even worse.  
Do all the database stuff in your controller. That way the view  
becomes simpler, and your code becomes testable.

Regards,  
/Daniel

---

<div class="post-metadata">

**Author:** ![dhaval\_parikh33](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bcef8e/32.png) [@dhaval\_parikh33](https://www.ruby-forum.com/u/dhaval_parikh33)\
**Post date:** [October 4, 2007, 11:02am UTC](https://www.ruby-forum.com/t/write-insert-query-in-views/116199/3 "2007-10-04T11:02:39Z")

</div>

well yes I know that but i actually want to do this while listing of the  
values…

in my list.rhtml i m having @email which is storing email addresses so i  
want to store those into my db how could i do that?

please let me know…

thanks