My understanding was that MySQL does not allow multiple statements to be executed in one shot as a means to try and avoid piggy backing and hacking. Could be wrong, though.
On Apr 21, 7:52 pm, Fearless Fool <[email protected]> wrote: > Frederick Cheung wrote: > > when connecting via activerecord you're using a different client so > > you get to skip the delimiter stuff. > > > Fred > > Lovely. I commented out the DELIMITER calls, and sure enough, it works: > > ActiveRecord::Base.connection.execute('DROP FUNCTION IF EXISTS > `coverage`;') > # ActiveRecord::Base.connection.execute('DELIMITER $$') > ActiveRecord::Base.connection.execute(sql_body) > # ActiveRecord::Base.connection.execute('DELIMITER ;') > > I look forward to the day when I know epsilon more than someone else on > this list and can help them as much as you've helped me. > > Best, > > - ff > -- > Posted viahttp://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/rubyonrails-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
