How to run direct DML (insert or update)


#1

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 ?


#2

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


Posted via http://www.ruby-forum.com/.


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

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

or generally:

.connection.execute()


#3

Thanks Richard it works perfectly