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 ?
on 2006-05-19 07:33
on 2006-05-19 15:30
On Friday, May 19, 2006, at 7:33 AM, Glenn Cadman wrote: > >-- >Posted via http://www.ruby-forum.com/. >_______________________________________________ >Rails mailing list >Rails@lists.rubyonrails.org >http://lists.rubyonrails.org/mailman/listinfo/rails Item.connection.execute("select count(*) from items") or generally: <Model>.connection.execute(<SQL>)
on 2006-05-22 03:40
Thanks Richard it works perfectly