similar to: mysqlWriteTable . error in your SQL syntax?

I have a data.frame obj with 5 columns whose colnames match the fields in my "contact" table. The only other field my MySQL table has is an id field which is the PK and is set to auto increment. I'd like to load this data.frame using something like: dbWriteTable(con, "contact", dat, append=TRUE) However, I get this error: Error in mysqlExecStatement(conn, statement,

Dear All, i want to ask about contribute for centos, in site http://wiki.centos.org/Contribute i see L10n, my question how to register to L10n so i can contribute how to centos for my languange (Indonesia), whether in CentOS Community don't a kind of ambassador centos for example "ambassador fedora" and i am sorry speak english still bad Thank for information :) With best regards,

Creating a temp table isn't completely intuitive with MySQL 5 and R 2.8..1, but it can be done. > library(RMySQL) Loading required package: DBI > con <- dbConnect(dbDriver("MySQL"), dbname = "foo", user="me",password="secret") > x<- data.frame(1:10) > colnames(x) <-c("x") > dbWriteTable(con, "#x", x,

Hi, I am new to R and I want to export data into Stata. Could somebody help with that? Thanks a lot. This is the code I am using: > setwd("D:/datasets/Seg-bcn/ESBD") > data1 <- readRDS("r17045_ESDB_Habitatges_BDD_V_1_0.rds") > library(foreign) > write.dta(data="data1", file = "D:/datasets/data1.dta") Error in write.dta(data =

Hi, i getting following error and don't know doing something wrong. >mysqlWriteTable(con,"model1",model1,overwrite=T) Error in "[.data.frame"(value, from:to, drop = FALSE) : undefined columns selected In addition: Warning message: drop argument will be ignored in: "[.data.frame"(value, from:to, drop = FALSE) Exactly the same code, database and data

Hi R-users! Can anyone tell me what this error message refers to exactly > a<-c('m','f','m') > b<-c(1:3) > st<-c(1:3) > data.frame(a,b,st) a b st 1 m 1 1 2 f 2 2 3 m 3 3 > data.frame(a,b,st)->l > p<-svydesign(ids=~1, data=l) > pop<-c('(intercept)'=100, st1=10,st2=20) > calibrate(p,~st, pop) Error in

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

There is a little problem in handling logicals in RMySQL: # here is the MySQL connection > con <MySQLConnection:(1816,0)> # here is the data frame > print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE))) x y 1 TRUE FALSE 2 FALSE TRUE # as promised, the two data frame columns are identified as logicals and # the field types are set to tinyint > field.types <-

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

I'm having some problems with valid field names when using RMySQL to interface R (version 1.7.0, under RedHat9.0), to MySQL (4.1.0-alpha). I think I've spotted the problem and a solution (which is working for me), but I wanted to share this with you as I may be missing something. (Note: I'm aware that this is an old R version, but I've checked the code of the lastest version of

Hi, I am trying to do my first puppet configuration, already installed the puppetserver and client, in this link show my configuration and my puppet structure: http://paste.pocoo.org/show/212227/ But when i run the client side daemon i get this message: info: /Class[main]/Node[basenode]/Class[inittab]/File[inittab]/source: No specified sources exist err:

Hi , library(foreign) write.dta(data1, "data1.dta") should work. The file will be saved in the working directory. Use getwd() to know the working directory. Best wishes Amalraj Raja -----Original Message----- From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of rosario scandurra Sent: 22 March 2018 07:47 To: r-help at r-project.org Subject: [R] exporting data to stata

Hi all, I have a question on the package « survey” I have some difficulties to use the function ‘calibrate’. Although it works well with one single factor variable, I cannot use it for 2 and get the message “Erreur dans regcalibrate.survey.design2(design, formula, population, aggregate.stage = aggregate.stage, : Population and sample totals are not the same length.” Here is the format

Hi everyone, I''m Ezequiel from Buenos Aires. I''m new in this list, so please forgive me if my questions are not the correct one''s fro this alias. I''m working as a campus ambassador in Sun, while finishing my engineer degree, creating communities around opensolaris in Argentina. I discovered this project, and this group, looking for something that I could

On Thu, Mar 22, 2018 at 4:52 AM, Raja, Dr. Edwin Amalraj <amalraj.raja at abdn.ac.uk> wrote: > Hi , > > library(foreign) > write.dta(data1, "data1.dta") > > should work. I don't think so: > library(foreign) > example(svydesign) > write.dta(dstrat, "~/Downloads/foo.dta") Error in write.dta(dstrat, "~/Downloads/foo.dta") : The

I'm trying to track down the source code to Ogg Squish 0.98 for testing. If someone has a tarball somewhere (please look!) I would greatly appreciate if they could email it to me. I've searched google high and low, it apparently doesn't exist anymore. Apparently, free software *can* disappear! -- "The question is no longer between violence and non-violence; It is between

Posted on behalf of Mark (m.roth at 5-cent.us) who is currently experiencing technical difficulties with his Internet connection --------------------------------- > On Fri, 2015-04-03 at 11:23 -0400, Lamar Owen wrote: > >> I really think that if someone is actually interested in helping the project, rather than being a backseat driver and griping at every change ........

Hi i have the running i both sides, client and server sides the puppet 0.25.4 Get this error on server side: puppetmasterd[5363]: Report puppet_dashboard failed: wrong Content-Length format And receive this error on my client side: warning: Value of ''preferred_serialization_format'' (pson) is invalid for report, user default (b64_zlib_yaml) I am getting any reports on my

Hi all, FOSDEM is coming and it would be nice if CentOS users and developers are present. FOSDEM will take place at 24 and 25 february 2007. (so mark those dates in your calendar!) I guess what we need is a wiki page about FOSDEM linked from some 'CentOS events' page and then people can start planning and indicating who's coming and what the topics could be. Since the developer