similar to: Why does 'exists' need a quoted argument?

Is it true that append=T does not work in assignTable() in RMySQL ? More specifically: I cannot append a data.frame to an existing table in a MySQL database, although I can use the same data.frame to create a new table. Even more specifically: > assignTable(con,"employee",dita,append=T) Error in execStatement.MySQLConnection(con, statement, ...) : RS-DBI driver: (could not

Hi, I'm experimenting with using (R)SQLite to do data management. Here are two little problems that I've encountered: 1. The presence of ',' in string values causes trouble since ',' is also the delimiter used in the SQL statement. 2. A newline '\n' line attached to the last string value of each row. Some examples: > library (RSQLite) Loading required

We are running dovecot to provide authentication for postfix, using two mysql servers in a multi-master replication set as the password source: ---------------------------------------- # 2.0.13: /etc/dovecot/dovecot.conf # OS: Linux 2.6.37-gentoo-r4 x86_64 Gentoo Base System release 2.0.2 auth_mechanisms = plain login digest-md5 cram-md5 auth_verbose = yes passdb { args =

I am getting a-mail with security run output from one of my 9.2-RELEASE servers whose primary role is mysql server: sql1.kappastar.com login failures: Nov 18 02:11:09 sql1 sshd[58619]: Invalid user this-is-not-an-attack from 188.95.234.6 Nov 18 02:11:17 sql1 sshd[58621]: Invalid user this-is-not-an-attack from 188.95.234.6 Nov 18 04:54:10 sql1 sshd [59190]: reverse mapping checking getaddrinfo

I feel a bit embarassed by this, but I have not managed to find out how: I have a data frame containing measurements over time for a number of different locations: > str(milk) `data.frame': 845 obs. of 3 variables: $ date : num 1987 1987 1987 1987 1987 ... $ value : num 5 1 2 5 1 1 2 3 2 4 ... $ location: Factor w/ 36 levels "Alta","And?y",..: 1 1 1 1 1 1

I am making a plot from R indicating an average, min and max value for a number of sample types. as horizontal lines with the sample types on the y-axis. (see http://home.newmedia.no/sickel/R.html for the plot and code) In some cases, the min value is the detection limit, and I would like to indicate that bu using a <, rather than the usual | I use for indicating the value. I am plotting each

I'm running 2.0.17 and I'm still seeing a decent amount of "MySQL server has gone away" errors, despite having multiple hosts defined in my auth userdb 'connect'. This is Debian Lenny 32-bit and I'm seeing the same thing with 2.0.16 on Debian Squeeze 64-bit. E.g.: Jan 12 20:30:33 auth-worker: Error: mysql: Query failed, retrying: MySQL server has gone away Our mail

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

I''m using standard barplot (Windows version 1.6.2 of R) to represent a certain weekly metric "v" and I would like to properly overlay on top of it its moving average "mean.8" (window of 8 weeks). I must be doing something wrong since the moving average (using "lines") doesn''t overlay properly, i.e., both x-scales do not match! ...

I am testing out the grid-plots, but get into a problem making a legend. I have a line plot and some points, following the model in grid.plot.and.legend() i manage to get the points correctly in the legend, but what do I do with the line? (Of cource, I can just draw a line at the right location on the plot, but I would prefer to use legend) Morten -- Morten Sickel Norwegian Radiation

I have a huge frame holding holding model results for a number of locations and time series: > str(tonedata) `data.frame': 434 obs. of 339 variables: $ VALUE : int 101 104 105 106 111 118 119 121 122 123 ... $ COUNT : int 2443 184 1539 1016 132 1208 1580 654 864 560 ... $ AREA : num 6.11e+08 4.60e+07 3.85e+08 2.54e+08 3.30e+07 ... $ D1_1958 : num 470 446 452 457 407 ...

Hi everyone: I?m one of the interns at RStudio this summer working on a project that helps teachers grade student code. I found an unexpected behaviour with the |==| operator when comparing |quote|d expressions. Example 1: |u <- quote(tidyr::gather(key = key, value = value, new_sp_m014:newrel_f65, na.rm = TRUE)) s <- quote(tidyr::gather(key = key, value = value,

Hi all, I''m stuck with a peculiar problem. I have CentOS 5.5 and Xen. I have numerous Windows 2003 guests and never had this problem. An application requires SQL server 2008 which is requiring Windows Server 2008. I downloaded the 2.8 Gig install DVD ISO. I create a new guest and connect the ISO as hdc. The system starts and says "Starting Windows" but hangs and no

Hi there I'm using dovecot-1.1b2/b3 with deliver. All information is stored in an SQL database and no errors related to this issue are written to the logs (actually I get no errors at all). I've run into at problem; FETCH BODYSTRUCTURE is broken after upgrading to dovecot 1.1b2 (same issue with 1.1b3). BODUSTRUCTURE only returns information from the first section (with incorrect

I am quite new to R, so please bear over with me if I have problems with the R terminology. I want to (try to) use R for some analyses within vegetation ecology, using the vegan package. I have my data in a postgresql database, and I manage to get them into R as a dataframe with columns for respectively: Name of the analysed m2, Name of the species, coverage of species in the square in %. I

Can someone please give me a clue how to 're'write this so I dont need to use loops. a<-ts(matrix(c(1,1,1,10,10,10,20,20,20),nrow=3),names=c('var1','var2','var3')) b<-ts(matrix(c(2,2,2,11,11,11,21,21,21),nrow=3),names=c('var1','var2','var3'))

Hi all Say I have a function: myname=function(dat,x=5,y=6){ res<<-x+y-dat } for various input such as myname(dat1) myname(dat2) myname(dat3) myname(dat4) myname(dat5) how should I modify the 'res' line, to have new informative variable name correspondingly, such as dat1.res dat2.res dat3.res dat4.res dat5.res stored in the workspace. This is only an example of a complex

Dear R devel, being constrained to a windows environment at work and having colleagues being accustomed to the Microsoft Office Suite, I was looking for a way to have the RweaveLatex driver for Sweave automatically generating 'win.metafile's in addition to the pdf graphics. Without this functionalilty, the generation of emf-graphics is quite laborious, I think: <<>>= plotit

Hi all, In a function, I need to get the name of a variable that has been used to call the function. For example, I want: --- 8< ------ toto <- 3 fun <- function(y){ nameOfY <-deparse(substitute(y)) cat("name is ",nameOfY) } fun(toto) # [1] name is toto --- 8< ---- But deparse(substitute(y)) does not work all the time, especially when we use generic function.

I am using RStudio Version1.0.143 on a Windows 7 machine. R version 3.4.0 I am trying to connect to a postgreSQL database with the following command, but I receive an error message that says my password is incorrect. Since I saved my password in a file, I think I remember it. I searched for a solution online, but cannot figure out what to do. If I have to change my password, please provide