What is this error all about? I m running a standard query like so:
time_range = (1.month.ago.beginning_of_month..1.month.ago.end_of_month)
Feed.find(:all, :conditions => [ created_at = ? AND id not in (?) , time_range, [1,2,3]]).count
任何想法? 成就
我有这个问题,解决办法是增加“日期”,以便它能够在几天内如:
time_range = (1.month.ago.beginning_of_month.to_date..1.month.ago.end_of_month.to_date)
我认为你的问题是,你正在做以下工作:<代码>created_at = ?, 时间_range/code>,时间_range不是具体价值,而时间 = 期望特定价值。 很难确切解释为何出现这一错误,但可以找到解决办法。
相反,我对此进行了审判,并做了大量工作。
1.9.3-p125 :014 > time_range = (1.month.ago.beginning_of_month..1.month.ago.end_of_month)
=> Sun, 01 Apr 2012 00:00:00 UTC +00:00..Mon, 30 Apr 2012 23:59:59 UTC +00:00
1.9.3-p125 :015 > Post.where(:created_at => time_range).where( id not in (?) , [1,2,3]).count
(0.3ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."created_at" BETWEEN 2012-04-01 00:00:00.000000 AND 2012-04-30 23:59:59.999999 ) AND (id not in (1,2,3))
=> 0
<>>>>>
Not directly related to the question, but you should place those conditions in scopes with semantic meaning so you would have Feed.from_last_month and something like Feed.not_with_ids([1,2,3])
问 问 题
Feed.from_month.not_with_ids([1,2,3]).count
关于警告检查的说明
collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...
We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...
As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...
I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?
I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...
I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml
guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...