similar to: How to merge multiple 'having' clause relation in rails 3

Displaying 20 results from an estimated 8000 matches similar to: "How to merge multiple 'having' clause relation in rails 3"

2011 Feb 09
1
Iterate over a list of input files?
Hi, I've got the following code which seems to work fine for a single file if I specify the file name explicitly in the code. What I need to do is run it on all the files in the directory tested and augment the data frame I'm building to have more results columns.How can I do that? Here's the code: library(chron) # .Holidays / is.holiday / is.weekend TStoDate = function
2012 Oct 14
0
Asking help about drawing and saving candle chart automatically....
Hello, I have trouble with saving and showing candlestick graph. I want to draw daily 1-minute candle chart per each day and save it repeatedly. The data I saved and is used in my code is as the following format: ----------------------------------------------------- Index,Open,High,Low,Close # header 2011-11-01 9:00:00 ,248.50,248.95,248.20,248.70 ... 2011-11-01 15:15:00
2007 Jul 18
5
Strange search result with conditions in find_by_contents
Hi, guys: Strange search result with conditions in find_by_contents! first of all, i''ve installed the acts_as_ferret to my project vender folder by ''ruby script/plugin install svn://projects.jkraemer.net/acts_as_ferret/tags/stable/acts_as_ferret'' in my SearchController def searchforum if !params[:doSearch].nil? if params[:searchTerms].nil? || params[:searchTerms] ==
2012 Feb 22
4
Week number from a date
Hi My data looks like this startDate="2008-06-01" dateRange =c( "2008-10-01","2008-12-01") Is there any method to find the week number from the startDate range ----- Thanks in Advance Arun -- View this message in context: http://r.789695.n4.nabble.com/Week-number-from-a-date-tp4410223p4410223.html Sent from the R help mailing list archive at Nabble.com.
2007 May 02
4
Wrong total_hits when using conditions in find_by_contents
In my model Topic: acts_as_ferret({ :fields => {:username => {:store => :yes, :boost => 30}, :subject => {:store => :yes, :boost => 20}, :body => {:store => :yes, :boost => 10}}, :remote => true }, { :analyzer => Ferret::Analysis::RegExpAnalyzer.new(/./, false) }) def self.full_text_search(q, options = {}, find_options = {}) return nil if q.nil? or
2012 Jan 17
3
Using !is.na() in a HAVING clause in sqldf() XXXX
Hi everyone, I have the following: sqldf("select Premie,count(tpounds) N,avg(tpounds) Avg_Weight, stddev_samp(tpounds) StdDev from children group by Premie having !is.na(Premie)") sqldf() does not like the !is.na(Premie) specification. How does one exclude a "missing" group in an aggregated query using sqldf()? Thanks! Dan [[alternative HTML version deleted]]
2008 Mar 14
2
MySQL IN clause for an array of strings
I''m trying (for the first time) to build an IN clause from an array of strings and getting an error using MySQL as the DB... Here''s the code I''m using to build the clause: zips_clause = '''' user.get_zipcodes.each {|z| zips_clause += '','' if !zips_clause.blank? zips_clause += ''\'''' + z +
2014 Feb 17
1
Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'
Hi List, I have a problem with dovecot 2.2.12 and sieve-filter call: su -c 'sieve-filter -D -v -W -C -u account at domain.tld /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail gives me sieve-filter(vmail): Error: user account at domain.tld: Auth USER lookup failed sieve-filter(vmail): Fatal: Internal error occurred. Refer to server log for more information. on log file I see
2007 Jan 09
9
Date Approximation in Specs
The floating-point expectations allow for an error tolerance. Is there any similar facility for dates? For example, say I have a custom class that handles date/time spans and I want to spec it: context "A DateRange span" do specify "should know when a week ago is :)" do d = DateRange.new d.last_week.should_be_close_to(1.week.ago, 24*60*60) end end The idea
2006 Mar 14
0
[Fwd: Re: [PATCH] TC: bug fixes to the "sample" clause]
List admins. Can you fix the issue described below, ie jamal''s posts to the lists bouncing, please? -------- Forwarded Message -------- From: Russell Stuart <russell-lartc@stuart.id.au> To: hadi@cyberus.ca Cc: Stephen Hemminger <shemminger@osdl.org>, netdev@vger.kernel.org Subject: Re: [PATCH] TC: bug fixes to the "sample" clause Date: Tue, 14 Mar 2006 13:16:52
2006 Aug 14
1
Connection scripts with the 'prexec' clause
Hi all, I am running Samba 3.0.20B on an AIX server with SECURITY=USER using an LDAP backend. I am looking for a way to capture the actual username(%USER_NAME%) that the client user is logged onto his individual workstation with and compare it with the user(%u) they are connecting with the share as. If they are different, I want to reject the user's connection. After doing some
2013 Oct 30
1
Lazy evaluation of exec clause in ssh Match statement
Hello, At present, if a ssh Match block contains an exec clause, the specified command is executed regardless of whether any preceding clauses are true. Thus, Match host !*.* exec "some_command %h" ... would always execute some_command regardless of whether the host matches the preceding pattern. That seems undesirable, particularly as the user-specified command may do name lookups
2009 Mar 13
1
Rd \usage clause for an S4 replace method
Given S4 methods [ and [<-, how do I write the Rd-file usage clause for the latter one? What I have now is: \S4method{[}{TimeSeries,TimeDate,missing}(x, i, j, ..., drop) \S4method{[<-}{TimeSeries,TimeDate,missing,ANY}(x, i, j, ..., value) which results in the following output: ## S4 method for signature 'TimeSeries, TimeDate, missing': x[i, j, ..., drop]
2010 Jul 19
1
Unknown column username in where clause
Version: Dovecot 2.0 rc2 I'm testing Dovecot with MySQL quotas but I get always this error for incoming mails: tux dovecot: lmtp(4928): Error: user testuser at dlutt.de: Auth USER lookup failed tux dovecot: auth: Error: mysql: Query failed, retrying: Unknown column 'username' in 'where clause' I dont' know where the field "username" should come from because I
2006 Jun 18
3
Ambiguous clause error
I''m trying to query one table to ultimately display the relate info from another table. I have 2 tables: "posts" and "numbers". I''m trying to do a query like this: @numbers = Number.find(:all, :conditions => [ ''(user_id) = :id'', {:id =>
2013 Mar 29
3
if clause in data frame
Hi, final<-data.frame() ?? for (m1 in 4:10) { ?????? for (n1 in 4:10){? ?????????? for (x1 in 0: m1) { ????????????? for (y1 in 0: n1) { final<- rbind(final,c(m1,n1,x1,y1)) res}}}} ?final1<-within(final,{flag<-ifelse(x1/m1>y1/n1, 1,0)}) ?head(final1) #? m1 n1 x1 y1 flag #1? 4? 4? 0? 0??? 0 #2? 4? 4? 0? 1??? 0 #3? 4? 4? 0? 2??? 0 #4? 4? 4? 0? 3??? 0 #5? 4? 4? 0? 4??? 0 #6? 4? 4?
2007 Jul 31
5
Group by clause
Hi Does acts_as_ferret support a :group clause? For e.g any rails options like :select or :group etc? or is it that it supports only few of such options?Like it supports :include Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/ferret-talk/attachments/20070731/a74fb666/attachment.html
2009 Oct 29
4
Unknown column 'quotes.organisation_id' in 'where clause': SELECT * FROM `quotes` WHERE (`quotes`.organisation_id = 1036)
Hi, I have a small app that needs to keep track of quotes, and organisations. An organisation can either be the unit who finally receives the goods (the end_user) or and intermediary (customer) (and in some cases both) An Organisation will (hopefully :) ) have many quotes; and a quote can belong to an organisation, either as a customer or as an end_user or both. So the quotes table
2010 Feb 10
0
boxplot label cleanup
The boxplot below is close to what I would like, but needs some clean up. I've been unable to address the following: 1) How can I use the full extent of the plot space (there is white space on either side of the data)? 2) How can I reduce the # of month labels (e.g. every 3rd month Jan Mar Jun...) but still keep them staggered? 3) The year labels at the top of the plot have been positioned
2006 Nov 02
6
Multiple items in the where clause while updating...
Hi The following is a database table named friends. +-----+------+------+-------+ | sid | id | fid | ftype | +-----+------+------+-------+ | 30 | 1 | 2 | F | | 31 | 1 | 3 | R | | 32 | 3 | 2 | F | | 33 | 3 | 4 | F | +-----+------+------+-------+ I want to update the ftype field based on id and fid. I want to achive the following. Update friends