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