# How to run direct DML (insert or update)

**URL:** <https://www.ruby-forum.com/t/how-to-run-direct-dml-insert-or-update/61009>\
**Category:** Rails\
**Created:** [May 19, 2006, 7:33am UTC](https://www.ruby-forum.com/t/how-to-run-direct-dml-insert-or-update/61009 "2006-05-19T07:33:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![glenn](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4bbf92/32.png) [@glenn](https://www.ruby-forum.com/u/glenn)\
**Post date:** [May 19, 2006, 7:33am UTC](https://www.ruby-forum.com/t/how-to-run-direct-dml-insert-or-update/61009/1 "2006-05-19T07:33:29Z")

</div>

I want when the user clicks on a button on the browser  
“Perform monthly billing run” the controller to lanch a sql DML  
statment to be called (in the model?) than runs something like

“insert into billing (item, qnt, total\_cost, billing\_run\_timestamp  
select item, qnt, item\*cost as total\_cost, timestamp  
from services  
where service\_end\_date is null”

How can I run a DML (insert, update, delete) direct sql statement ?

---

<div class="post-metadata">

**Author:** ![glenn](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4bbf92/32.png) [@glenn](https://www.ruby-forum.com/u/glenn)\
**Post date:** [May 19, 2006, 3:30pm UTC](https://www.ruby-forum.com/t/how-to-run-direct-dml-insert-or-update/61009/2 "2006-05-19T15:30:51Z")

</div>

On Friday, May 19, 2006, at 7:33 AM, Glenn C. wrote:

> –  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

Item.connection.execute(“select count(\*) from items”)

or generally:

.connection.execute()

---

<div class="post-metadata">

**Author:** ![glenn](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4bbf92/32.png) [@glenn](https://www.ruby-forum.com/u/glenn)\
**Post date:** [May 22, 2006, 3:40am UTC](https://www.ruby-forum.com/t/how-to-run-direct-dml-insert-or-update/61009/3 "2006-05-22T03:40:38Z")

</div>

Thanks Richard it works perfectly