similar to: Parsing a SQL file directly into activerecord::execute method

In an effort to not be a vamp. (Thanks Amy) Here is the error message = I''m getting. Mysql::Error: #42000You have an error in your SQL syntax; check the = manual that corresponds to your MySQL server version for the right = syntax to use near ''=A1=C9=A8[=A9=B4#Globals = (ActiveRecord::StatementInvalid) SET @rightnow =3D current_timestamp; It appears that Active Record is

It doesn''t like SET commands, or #Comments, etc. Looks like no way = around this without using forgoing active record. I don''t really want = to do that at this point. --------------------------- Brian Corrigan --------------------------- -----Original Message----- From: rails-bounces@lists.rubyonrails.org = [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Brian

Hey Folks, My app compares the last known set of files located on a series of servers against a current snapshot for auditing purposes. Its working really well, and I''ll open source it when its complete! Here''s my current issue (and forgive me, I started life as a DBA and I constantly want to revert to connection.execute.) The tables to store my objects are

hi there. Has anyone ever have this happen to them where they did one of these raw ''execute fk_'' sql commands in their migrations (like seen in the depot app in the agile rails book when they were building the line item active record...anyways, now i can''t get those foreign keys to delete, nor can i even get the column_id to delete too..so weird.. humm..just

Hey Ryan, I asked this question awhile back, but any support planned for table returning functions, or stored procedures? I''m envisioning basically a mutable model class where you have 1 or more instance variables defined (with default values) that are used in the SQL queries as input parameters. When you instantiate the class you can specifically define these parameters or use the

Hey Folks, I''ve written a script to generate a list of all files on a machine, then zip the results. ?I''m going to stick a web front end on it, and use it to audit some file servers. The problem is that the ZIP compression/decompression isn''t working, but its not what you might think. ?The script completes, but seems to not actually write anything. Here is a short

R-devel community: I have encountered some unexpected behavior using iconv, which may be the source of errors I am getting when connecting to a UTF-16 -encoded SQL Server database. A simple example is below. When researching this problem, I found r-devel reports of the same problem in threads from June 2010 and February, 2016, and that bug #16738 was posted to Bugzilla as a result. However, I

How do you clean up your app folder to place onto the server? I want to get rid of all the .svn stuff. Seth Buntin -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060317/cc81d9f7/attachment.html

Ok, So I followed the directions.. I did a ''gem install markaby'' (which sounds like its enough to get me going for rails), but I wasn''t sure, so I tried to install the plugin as well. Plugin installation fails looking for a file: Script/plugin install http://code.whytheluckystiff.net/svn/markaby/trunk Outputs this error: + ./trunk/svnindex.xsl

Hey Guys, I''m absolutely stumped by this error. I haven''t seen it during any of my development, or working in production until just this week. Randomly, rails app becomes totally inaccessible until I restart the webserver. I tossed in some custom error messages stuff, so I could get the client to send me mail when it broke, and this is the error I''m getting:

Hey Folks, I''m deploying a camping app on an internal Apache2 + FastCGI server at my office. Of course, on my Mac it works great, but I can''t get things to work with Apache and FCGI. I''ve followed the directions on why''s page documenting how to do this, but I''m getting the following error in my Apache error.log file: FastCGI: (dynamic) server

If I establish a new connection with a new adapter (ie. switch from mysql to postgresl) the generated sql is still mysql specific. I tried all sorts of reset methods on AR::Base but to no avail. There must be something being memoized on ActiveRecord base that has to do with the adapter and it doesn''t get cleared when you establish a connection with a new adapter. I know this

Hi All, I''m having a slight issue with one of my Rails models. It''s nothing I can''t work around (as I''ve already done so), but I''m interested in the actual issue. Basically, I have an ActiveRecord-based class named "Events" that I''ve connected to a remote database using "establish_connection". It all works fine and I can

Estimado José, por lo que estuve mirando aqui https://en.wikipedia.org/wiki/Wilcoxon_signed-rank_test, en ?wilcox.test y en libros de papel ... los datos deben cumplir ciertas condiciones, quiza la mas restrictiva es que sean pareados ... si no lo son, quiza esta variante del test es mas apropiada: https://en.wikipedia.org/wiki/Mann-Whitney-Wilcoxon_test la que en R se aplica usando el mismo

I just setup a new server for a client and everything is running well. I added and setup all the users from the cli just because that's how I'm used to doing it. I tried using the samba gui that comes with CentOS 4.03 and I tried Webmin but nether one will add the user proberly to the tdbsam database. They add the user fine to the /etc/passwd file but samba does not get updated

Hello everyone, I just showed a friend a prototype of a site offering a service I''m trying to sell (sorry, not on the Internet yet - he saw it at my house). His comment: "Looks like it does everything, but also looks pretty ugly. You''re not going to wow anybody with that". Sitting back and thinking about it, he''s dead right - it needs some bling to make it

Hello all together, I've got here a very strange problem. I've set up a vpn with freeswan between two subnets over the internet. Now I can ping from behind to behind. With Windows 98 I can search a computer which is in the other subnet and find the the computer. But...only the other computer is NOT a samba server. Means a w2k or w98 is ok. If I'm looking for the samba in the other

Hey All, I have two tables.. One belongs to another. Why can''t I reference table1.table2.attribute? Specifically, using scaffolding: property.rb - has_one :PropertyType property_type.rb - has_many :Properties property_controller - def list @property_pages, @properties = paginate :properties, :per_page => 10 end list.html: 1. <% for property in @properties %> 2.

Is it possible to have controllers named the following? /admin /admin/user If not, is there some way to get it to work with routes? I want to have some actions at the url /admin/<action> and some at /admin/user/<action> (obviously in admin/user controller). Thanks!!!

How do you execute arbitrary SQL with ActiveRecord? I need to insert 40,000+ records, and the usual way is way too slow. I''m using Oracle Thanks Chris -- Posted via http://www.ruby-forum.com/.