similar to: Using SQL "IN" with RJDBC or RMySQL

Displaying 14 results from an estimated 14 matches similar to: "Using SQL "IN" with RJDBC or RMySQL"

2010 Jun 08
9
[Rails Heroku] Problem with saving object (on heroku hosting)
Hi All, I have some strange problem which appears only on heroku hosting 2.3.5 default stack (not on my local computer) I have some models. Here they are: class Contact < ActiveRecord::Base belongs_to :user belongs_to :type, :class_name => "ContactType", :foreign_key => "type_id" validates_presence_of :name, :on => :create, :message =>
2008 Jun 06
2
joining tables
Hi I have 3 tables as 1) user_groups id | contact_id | group_id | group_user_type_id 2) contact id | name_first | name_last | 3)contact_email_addresses contact_id | contact_email_address_type_id | emailaddress Now I have group_id sa for example 68 What I want is from contact_email_addresses table get all the emailaddress with contact_email_address_type_id=2 for the contacts
2006 Jun 26
2
n-way has_mant :through
I''m trying to setup some mildly complex associations for a project we''re working on and can''t seem to find much documentation on n-way has_many :through associations. I have the following models: Person, PhysicalAddress, EmailAddress, PhoneNumber. Each person can have multiple PhysicalAddresses, EmailAddresses, and PhoneNumbers, and multiple people can share the same
2006 Jun 23
3
form_remote_tag is not passing form params
I''ve searched and searched and searched again, and I cannot find any help with this problem. There''s an identical problem on this forum, but it was never resolved. I''ll try to re-open the subject with a bit more information. Problem: The form_remote_tag() method in my "list" view is not passing the params[] hash of the values stored within my form.
2013 Mar 09
1
lmer (LME4) and survey standard error
Hello, I am using lmer (LME4) to build a model from data for 19 different neighborhoods drawn, in part, from the American Communities Survey (ACS). The ACS data is static while other variables change over the five years under investigation. I am new to mixed effects models and was hoping that someone could suggest a way to include the ACS standard error for each covariate into the model. I
2011 Dec 03
1
side-by-side map with different geographies using spplot
Hello, I want to create side-by-side maps of similar attribute data in two different cities using a single legend. To simply display side-by-side census block group boundary (non-thematic) maps for Minneapolis & Cleveland I do the following: library(rgdal) library(sp) Minneapolis=readOGR("../Minneapolis/Census/2010/Census_BlockGroup_GEO/","tl_2010_27053_bg10")
2011 Dec 26
2
Recoding multiple TRUE/FALSE columns into a single list of TRUE columns
Hi everyone, I need to recode multiple columns in a dataframe into a single column in a variety of different ways. Often the values will be TRUE/FALSE and I want a list of the columns that are true as in the Result column below: P1 P2 P3 P4 Result 1 0 0 1 1 P3,P4 2 0 1 1 1 P2,P3,P4 3 1 0 0 0 P1 4 0 0 0 0 NA 5 1 1 1
2007 Mar 01
0
Reshape data
I have two data frames with a number of common variables that I wish to put into "long format". The first contains the variables es(Csales) [1] "terr" "Dec.02" "Jan.03" "Feb.03" "Mar.03" "Apr.03" "May.03" "Jun.03" [9] "Jul.03" "Aug.03" "Sep.03" "Oct.03"
2012 Dec 26
0
Presence Registration on the D40
So I'm working with our Digium D40's and we're not using DPMA. This video ( http://www.youtube.com/watch?v=zcuocp01pfM#t=35s ) shows presence information being displayed in the Contacts application. Obviously the video is showing DPMA in play. Is it possible to enable this functionality without it? Is this status information only available on higher-end Digium phones? In the contacts
2006 Jul 27
1
response from ajax request
Hi, newbie here. I am trying to implement a filtering interface using observe_field. Using firebug I can see that I am getting the properly rendered html blob back in the response, but when it get inserted into the dom element that I am targeting, the plain html elements from the partial template have been stripped, leaving only the elements inserted via the <%= statements. I would
2016 Dec 20
2
ldaps:// referrals from DC
I'm not an LDAP expert and I need an help to understand the following situation. I'm configuring a web LDAP addressbook (roundcube) against a Samba 4.4 DC to use simple binds over ldaps://. My troubles with Samba 4 DC start when the server response contains a referral with ldap:// URI scheme.  The client fails without messages to error logs. This does not happen against a Windows Server
2016 Dec 20
2
ldaps:// referrals from DC
Hi Marc, thank you for your quick response! On Tue, 2016-12-20 at 17:44 +0100, Marc Muehlfeld via samba wrote: > > I haven't tried it, but what is wrong with STARTTLS? Nothing is wrong with STARTTLS (if the client supports it)! In my case I disabled referrals chasing in roundcube, as workaround. The reason I ask here is: MS DC gives a different response, and looks more
2012 Apr 01
1
trouble with small multiples on a date variable
Hello, I am loading a DBF file into R via JGR and am having trouble creating small multiple histograms on a date variable. Hist() handles the variable correctly. But I've been unable to work with lattice or ggplot2 despite trying format() and as.POSIXct(). Dates are in the format "2010-05-15" and the grouping variable is categorical. I'd appreciate it if someone would provide an
2012 Apr 04
0
crosstabs and histograms with flexible binning of dates
Hi, First, thank you to Duncan Mackay for getting me started processing dates with R. Unfortunately, I need to do a little more than I initially expected. I have 5K lines of data that look like this: ID AREA DATE 0001 Center 2010-10-15 0002 Center 2010-01-02 0003 NorthWest 2010-02-05 0004 SouthWest 2010-05-11 I would like to create a script to create crosstabs like