similar to: RMySQL 0.7-3

For those R user's who don't subscribe to R-sig-db and are having troubles with the latest RMySQL binary on CRAN, please read the email thread at the end of this message. RMySQL 0.7-2 does work with MySQL 5.1, however the CRAN binary is linked against the 5.0 version. Best, Jeff -------- Original Message -------- Subject: Re: [R-sig-DB] Problems with RMySQL and MySQL server version

I'm currently working on embedding R into the Apache2 webserver (with some positive results...), but I'm struggling to identify the best way to expose the apache data and functions to R. A couple of thoughts: In light of the recent discussion on "S3/S4 classes performance comparson", I'm leaning toward implementing the interface with S3 style classes. I appreciate

Hi, Is this sufficient? if (.Machine$sizeof.pointer==4){ cat('32\n') } else { cat('64\n') } Or is it better to test something in R.version, say os? I'd like to use this to specify appropriate linker arguments when building the RMySQL windows package. Jeff -- http://biostat.mc.vanderbilt.edu/JeffreyHorner

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

Hi, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"condition"

In R-2-4-branch r39548, Rcons_vprintf is called from stdout_vfprintf when R_Outputfile is NULL. When called and output is greater than R_BUFSIZE, output is truncated to R_BUFSIZE. Here's a one-line fix: Index: src/main/printutils.c =================================================================== --- src/main/printutils.c (revision 39548) +++ src/main/printutils.c (working

A professor here at Vanderbilt sent me the following code. Each of the text strings should right justify against the center vertical bar, but because of font issues it doesn't. I understand that there are workarounds, but I was just curious if this was consistent across all platforms. On linux with R 2.7.1 and R-trunk (r46103), both acrobat reader 8 and kpdf render it incorrectly. How

I have a 64 bit machine running 64 bit windows 7 pro, 64 bit MySQL, and 64 bit R 2.11.1. I have also installed RTools for 64 bit windows for this version of R (archive name is oldWin64toolchain.zip; the install path for its contents is C:\RTools, if that matters). I can open up a commandline window and invoke any of the programs in both bin directories (both added to the system path). There are

Hello all, I've been working on a new R Graphics device that targets Adobe's Shockwave Flash format (SWF for short). It uses http://www.libming.org/ on the backend. Here are some example outputs so far: http://160.129.129.41/~hornerj/plots/ Once you click on the above, choose a directory like 'smooth' and then click on test.html to see a side-by-side comparison of the swf

I am having trouble loading RMySQL after installing it. I have looked at archived r-help files and it seems many people have had issues, but I didn't find my specific issue. I also went to the webpage at Vanderbilt (http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the instructions as best I understood them: - I created a file called Renviron.site under

Byron, I just read your blog (statcomp.blogspot.com, linked from your other post) and rand across your idea of an R/Flash graphics device. I've also been giving this some thought because of this amazing interactive flash app: http://tools.google.com/gapminder and others from http://www.gapminder.org/. I would love more than anything to work on this. The only hitch is that I'm so

Hello, I've been wondering why my no-optimization R-devel builds have been hanging during "building/updating package indices ...". I tracked it down with gdb to this line from do_basename in utils.c: while ( *(p = buf + strlen(buf) - 1) == fsp ) *p = '\0'; Now, imagine if your compiler places the variable fsp immediately before buf on the stack, and strlen(buf) is 0.

I was writing Rd documentation for a new package when I came across this issue. Here's the smallest example: > library(tools) > cat("\\examples{x <- '<%=rnorm(1)%>'}\n",file=file.path(tempdir(),'test.Rd')) > readLines(file.path(tempdir(),'test.Rd')) [1] "\\examples{x <- '<%=rnorm(1)%>'}" >

And on that note, here is a function that I use to get around it: -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Jeffrey Horner Sent: Friday, November 03, 2006 10:01 AM To: ryszard.czerminski at novartis.com Cc: r-help at stat.math.ethz.ch Subject: Re: [R] R CMD BATCH: unable to start device PNG ryszard.czerminski

Hello, ?DateTimeClasses states that "one can add or subtract a number of seconds or a 'difftime' object from a date-time object, but not add two date-time objects." So, is the below expected behavior? > x <- Sys.time() > x [1] "2007-02-21 16:19:56 CST" > x + as.difftime("1","%H") [1] "2007-02-21 16:19:57 CST" Warning

For embedded projects, one may want to eliminate the per-session temp directory created by InitTempDir() and just use a system-specific temp directory. Here's my solution: extern char *R_TempDir; void my_InitTempDir() { char *tmp; if (R_TempDir){ if (rmdir(R_TempDir) != 0){ perror("Fatal Error: could not remove R's TempDir!");

Hi everyone, I am trying to install the RMySQL package under windows xp. I've got the MySQL installed on the computer (MySQL server 5.1). I went through the steps presented on the webpage http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL and googled around and still can't find the answer. With the command readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2) I

Hi all, We have a user that would like to create pdf plots using the Arial font. One way for her to do this is to use the Cairo graphics device which produces pdf's beautifully and embeds fonts automatically. She could also install the msttcorefonts package from ubuntu to obtain the Arial font. The problem is that she is using Sweave() to produce a document that contains the pdf plots,

What ? ------ We are pleased to announce version 0.0.6 of littler What's new ? ------------ This version includes a bug fix or two as well as a number of small enhancements to the documentation. For OS X and the r/R confusion, our recommended suggestion is to call configure using either the --program-suffix=X or --program-prefix=Y option to have the binary and manual