similar to: dbSendQuery with R variables

Displaying 20 results from an estimated 300 matches similar to: "dbSendQuery with R variables"

2009 Nov 06
1
issues with SSOAP when wsdl has ComplexTypes
I recently started trying R and SSOAP and was able to successfully try a "hello world" service. I am now trying to get a more complicated interface to work with SSOAP and so far failed miserably at that and so need any help I can get from here. The service I am attaching is a prototype for a full service that would take information to identify a data source and a query to run and return
2006 Mar 22
0
Time table models and querying approach
I doing an app to allow people to search bus time tables by bus stop and time. My models are: Providers -> Services -> Runs -> Stops <- Stations Key: "->" denotes a one to many Providers = Bus companies Services = the bus number Runs = Columns on a bus time table Stops = Cells on a bus time table, basically a time Stations = Rows on a bus time table StationA 10:00
2023 Aug 17
1
UEFI syslinux PXE boot issues
On 8/17/23 03:55, AL13N via Syslinux wrote: > Steve Rikli schreef op 2023-08-16 16:31: >> On Wed, Aug 16, 2023 at 02:05:33PM +0200, AL13N via Syslinux wrote: >>> Joakim Tjernlund schreef op 2023-08-16 13:15: >>> > On Thu, 1970-01-01 at 00:00 +0000, AL13N via Syslinux wrote: >>> > > >>> > > I'm used to non-UEFI PXE boot, and I use it
2007 Jul 04
10
A More efficient method?
Dear Rhelpers, Is there a faster way than below to set a vector based on values from another vector? I'd like to call a pre-existing function for this, but one which can also handle an arbitrarily large number of categories. Any ideas? Cat=c('a','a','a','b','b','b','a','a','b') # Categorical variable
2008 Aug 13
3
Comination of two barcharts and one xyplot
Hi Rhelpers, I would like to have some help with a plot which is beyond my capabilities. This plot that I am seeking involves an overlay of two different barcharts and one xyplot. The code that I have used is the following : #save(df1,file="M:\\KBR\\df1.RData") load(file="M:\\KBR\\df1.RData") # df1$Year.ord created to obtain the right order i.e. 2015M < 2015K
2010 Aug 25
2
Removing inter-bar spaces in barchart
Rhelpers: I'm trying to make a barchart of a 2-group dataset (barchart(x~y,data=data,groups=z,horizontal=FALSE)). My problem is that I can't, for the life of me, seem to get rid of the inter-bar space -- box.ratio set to 10000 doesn't do much. Any ideas? I'd ideally want zero space between the bars. Thanks! --j -- Jonathan A. Greenberg, PhD Assistant Project Scientist
2010 May 26
2
R and ATLAS
Rhelpers: I recently installed the 64-bit version of R on my Debian system, and afterwards was asked if it was compiled using ATLAS. Is there a way to test to see if R is using ATLAS? --j
2010 Jan 30
2
Using auto.key with two variable plots
Rhelpers: Having a problem solving this. I have an xyplot call that looks like this: print(xyplot(temp_species_EAM_Pred_Pop$x+temp_species_NULL_Pred_Pop$x~temp_species_EAM_Pred_Pop$Action,main=current_species, xlab="Action",ylab="Predicted Pop", xlim=c(xmin,xmax),ylim=c(ymin,ymax),
2002 Feb 20
2
Code for bivariate Poisson regression?
Dear RHelpers, Does anyone know of any R code to perform bivariate Poisson regression (including random effects)? Best wishes Simon Simon D.W. Frost, M.A., D.Phil. Department of Pathology University of California, San Diego Antiviral Research Center (Formerly: UCSD Treatment Center) 150 W. Washington St., Suite 100 San Diego, CA 92103 USA Tel: +1 619 543 8080 x275 Fax: +1 619 298 0177 Email:
2008 Oct 17
1
missing Rversion.h and Rconfig.h when installing RSQLite under FC8
Hello, I am having problems installing RSQLite under FC8. The error message seems to indicate Rversion.h and Rconfig.h are missing. To illustrate the problem, I have copied below the output shown when I first install R (binary distribution) and then try to install RSQLite. Because the problem does not occur when installing RSQLite with R under Windows I suspect the problem is perhaps due to my
2006 Aug 16
2
adding multiple fitted curves to xyplot graph
Hello RHelpers, This may already have been answered, but despite days of scouring through the archives I haven't found it. My goal is to add multiple fitted curves to a plot. An example data set (a data frame named df in following code) is: x1 y1 factor1 4 1298.25 0.00000000 1 5 1393.25 0.00000000 1 6 1471.50
2004 Jul 09
1
creating plots by batch
Hello RHelpers! I'm very ashamed but.... I'm creating quite a lot of plots in a big loop...each times the program ask me : > Hit <Return> to see next plot: How do I avoid that? Many, many thanks as always.... Anne ---------------------------------------------------- Anne Piotet Tel: +41 79 359 83 32 (mobile) Email: anne.piotet@m-td.com
2010 May 13
1
Comparing histograms?
Rhelpers: I'm curious what the appropriate analysis to use for testing the hypothesis that two histograms are statistically different from one another? Thanks! --j
2007 Apr 27
1
add arrows to barchart with groups
Hello Rhelpers, I am trying to represent the following data (hereafter named donnees) in a barchart with a grouping variable : site traitement date s res 1 NT 17/10/2005 normal 76.2 1 T 17/10/2005 normal 103.2 1 NT 23/11/2005 tardif 81.6 1 T 23/11/2005 tardif 98 2 NT 15/10/2005 normal 72.71 2 T 15/10/2005 normal 94.47 2 NT 15/11/2005 tardif 79.65 2 T 15/11/2005 tardif 94.7
2009 Mar 02
1
initial gradient and vmmin not finite
Dear Rhelpers I have the problem with initial values, could you please tell me how to solve it? Thank you June > p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2))) Error in maxRoutine(fn = logLik, grad = grad, hess = hess, start = start, : NA in the initial gradient > p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2),method="BFGS")) Error in optim(start, func, gr =
2006 Nov 02
1
avoiding a loop: "cumsum-like"
Hello Rhelpers, I need to run the following loop over a large number of data-sets, and was wondering if it could somehow be vectorized. It's more or less a cumulative sum, but slightly more complex. Here's the code, and an example dataset (called tab in my code) follows. Thanks in advance for any suggestions! res<-0 for (i in min(tab$Date):max(tab$Date)) { if
2023 Aug 17
1
UEFI syslinux PXE boot issues
Steve Rikli schreef op 2023-08-16 16:31: > On Wed, Aug 16, 2023 at 02:05:33PM +0200, AL13N via Syslinux wrote: >> Joakim Tjernlund schreef op 2023-08-16 13:15: >> > On Thu, 1970-01-01 at 00:00 +0000, AL13N via Syslinux wrote: >> > > >> > > I'm used to non-UEFI PXE boot, and I use it for my network installer >> > > since forever ago.
2007 Mar 20
5
abline within data range
Dear R helpers, I would like to have abline, for a lm model for example, lying within data range. Do you know how to get it? Thank in advance Nguyen D Nguyen #CODE x<- rnorm(200, 35,5) y<- rnorm(200, 0.87,0.12) plot(y~x, xlim=c(0,50), pch=17, bty="l") abline(lm(y~x)) # I would like abline is between min(x) and max(x) [[alternative HTML version deleted]]
2013 Jul 15
2
Serialize data.frame to database
Dear R-Users, I need a very fast and reliable database solution so I try to serialize a data.frame (to binary data) and to store this data to an SQLite database. This is what I tried to do: library(RSQLite) con <- dbDriver("SQLite") db <- dbConnect(con, "test") dbSendQuery(db, 'CREATE TABLE frames("simID" INT, "data" BLOB)') data.bin <-
2009 May 06
2
rmysql query help
R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching for the name of the variable in the database and not the value of the variable. If I put it outside the quotes, then it complains