similar to: assign value to MySQL timestamp field

I have the following statement cl = ChatEvent.find_all("ev_type <> #{t} and chat_id = #{@params [:chat_id]} order by created_at") which produces the following 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 ''order by created_at)'' at line 1: SELECT * FROM

Hello- I''m new to the ruby-based schemas and migrations. As I''m looking over examples and such online, I see that many of them don''t make use of schema-enforced attributes. For example, instead of: t.column "post_id", :integer, :default => 0, :null => false They do: t.column "post_id", :integer So I''m wondering -- is this

Does anyone know how to view the new source in IE after an AJAX update? When I "view -> source" I get the original page source, not the page source as updated. Thanks in advance, Bill -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060403/e8d96b2e/attachment.html

To play with RJS I just made a "rake freeze edge". But this copies only the libs into vendor/rails and any attempt of "rake update_javascripts" fails. But all the he required javascripts are there, at: BASEPATH/vendor/rails/actionpack/lib/action_view/helpers/javascripts/ Except of prototype, they seem to have no version number, so I am asking whether I should take those

Cheers, I have a problem with 1.0 and a habtm relationship between User and Article. I want to save all articles that users read. I have these models: class User < ActiveRecord::Base has_and_belongs_to_many :read_articles, :class_name => "Article", :join_table => "read_articles" ... end class Article < ActiveRecord::Base has_and_belongs_to_many :readers,

Hello, I submitted a patch <http://dev.rubyonrails.org/ticket/3287> ( http://dev.rubyonrails.org/ticket/3287) a couple of days ago. The patch adds some methods into and changes the existing methods in the CaptureHelper module. It should not, as I can see, affect any existing Rails implementations. I added the relevant unit tests and all but one of the tests pass. The test that fails failed

I''m working on a RoR project and a requirement has popped up that would required certain actions to happen at certain time intervals (as opposed to having a user initiate the action). Is there anything similar to Java''s Quartz library, *nix cron, or anything of the like for Rails? I''m certainly willing to help with/test Ruby code if someone on the list is already

Textdrive upgraded to Rails 1.1 already. I have an older rails app, and am now getting the following error: c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0 /lib/active_support/depende ncies.rb:112:in `const_missing'': uninitialized constant LoadingModule (NameEr ror) from ./script/../config/environment.rb:91 from

Hi all, I submitted a patch the other day for an issue I ran into running an "add_column" migration on a sqlite3 database when there is existing data in the table, and the new column has ":null=>false". Details at http://dev.rubyonrails.org/ticket/5215. The issue I encountered was not picked due to the unit test not having any actual data in it before running the

Hello all, I just successfully updated my dev env to Rails 1.0. I then wanted to get .rjs templates working and followed Cody''s instructions at http://www.codyfauser.com/articles/2005/12/02/rails-rjs-templates-plugin . However, when I try to run ''rake test'' I get the following error: (in

I started two weeks ago with rails and im amazed of what can be done in a short time, i already finished the agile development with rails and some of the tutorials at the documentation section of the rubyonrails.com site. But i realize that many of the tutos and examples around the web and books are using earlier versions of rails (0.x.x) and some of that code and coding practices are

Rails 1.1 was a big upgrade with a lot of new features and we''ve been working hard since its release to polish off the kinks revealed after it was deployed to the masses. Rails 1.1.1 contains fixes for things like Prototype memory leaks in IE 6, Oracle adapter runnings, and a number of compatibility tweaks to make most older applications work. This release still doesn''t work

I have gotten acts_as_taggable to work for a test application as documented on taggable.rubyforge.org I am following Chad''s excellent examples in ROR Recipes Beta book. I have a few questions and hope that Chad or some other expert can help clarify them. 1. Why is the book suggesting to use taggings table instead of tags_contacts, as mentioned on taggable.rubyforge.org?

I am trying set up a rails app that utilizes components. I need to be able to pass some state (a bunch of name value pairs) from the Main controller to the component. Is there any way to pass this state info using render_component? Regards -- Posted via http://www.ruby-forum.com/.

Hi, I''m developing an application where I''ll have to store a lot of images coming from the users. And I''m still not sure if I should store them in MySQl as blob or just store them on filesystem. If I store them on filesystem, how to scale when I''ll have to have multiple servers ? Thanks, Pratik -- rm -rf / 2>/dev/null - http://null.in

I''ve been using Rails for more than six months and until today I had no problem with mysql connection. It''s a Mac OS X 10.4 box having rails installed and updated by gem. I use a remote mysql server no local instance installed. Here''s my config: development: adapter: mysql database: hdchat host: 10.0.0.1 username: webuser password: test: adapter:

I''m using the subdomains as accounts method fine on a project, but I''m wondering what is the best way to differentiate between account subdomains to access the app using an account, and www.domain.com and domain.com in order to show normal site content. I''ve noticed that on Backpack, it seems that when you leave the information pages and start using the app,

So my automated script caught this issue, though I think my email headers were bad, so rails-core has put the automated email on hold pending "moderation". I''ll fix that issue, and look at the one below as well. -------- Original Message -------- Subject: Rails AR/Oracle Unit Test: [4185] failed Date: Thu, 6 Apr 2006 08:32:04 -0700 From: Michael Schoen

I see in the new Agile Rails 2nd edition that components are going out of style? Is this so? has anybody abandoned the idea of components for helpers? Specifically I''m considering a menu sytem for a website that depends heavily on the users permissions to decide which menu options a user would need to see. I thought that components, since they have the logic in the controller and

I run a small web development company on the north side of Chicago and we''re looking for an experienced enterprise-level PHP developer to consult on a project or hourly basis. I know this forum is a Ruby group, but I know that a lot of you know PHP people - or started out as PHP coders. I''f you''re interested, shoot me an email. If this post is inappropriate