How do I run SQL scripts from rails? I have a testing menu item called "import data". How can I get it to call a SQL script file that will import the data into a MySQL table for me? -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060222/bd9dc5c7/attachment-0001.html
hi Larry try this #--------------------------------------------------------------- ActiveRecord::Base.connection.excute(sql_str) #--------------------------------------------------------------- regards Larry Kelly wrote:> How do I run SQL scripts from rails? > > I have a testing menu item called "import data". > How can I get it to call a SQL script file that will import the data > into a > MySQL table for me? > > > > -- > Best Regards, > -Larry > "Work, work, work...there is no satisfactory alternative." > --- E.Taft Benson-- Posted via http://www.ruby-forum.com/.