similar to: Re: R: Mailing Lists

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

Some functions in R need quoted arguments. Consider this list: help(rm) rm(a) is.na(a) get("rm") exists("rm") Can someone explain why 'get' and 'exists' require quoted object names? Would it make sense (more consistency) to have these functions check to see if the first argument is a string, and if not, then 'substitute' it? Intuitively,

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 =

It appears that fetch() gets only the first 500 rows by default. I don't see this in the documentation, but timeinfo <- fetch(rs) gets only 500 rows where timeinfo <- fetch(rs,n=-1) gets (correctly) 736 for the same query. Is this an undocumented feature? I played with this data for an alarming amount of time before I realized that I was missing a third of the data. I

Hi, I recently discovered the R program and I thought it could be useful to me. I have to analyse data saved as .Px file (x between 0 and 8 - .P0 files have 18 lines at the beginning that I have to skip). New files are generated everyday. This is my strategy : In order to analyse the data, I first want to copy the new data in a database in MySQL (which already contains the previous data). So

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

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

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

Hi, I have struggled to re-implement the RMySQL package after upgrading from SuSe 6.3 to 7.2 and from R 1.2.1 to R 1.3.1, to no avail It compiles happily but when loading the package I get the following error > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/home/jniesch/R_HOME/lib/R/library/RMySQL/libs/RMySQL.so":

Dear laurent, > But there are lots of commands I found in R docs which are "not found", > such as getTable. Deprecated (I successfully used dbListTables) or do I > simply miss a package ? >From RMySQL\NEWS: * added (almost) trivial convenience RS-DBI functions getTable(), assignTable(), existsTable(), and removeTable(). They all mimic the corresponding R/S get(),

I have just installed R on a Windows NT system. Unfortunately I am unable to open any of the data files I wish to work with. I have tried using read.table and scan and to the best of my knowledge am using the correct syntax. The error message I receive is Error in file(file, "r") : cannot open file [file name] I have the data in text files in white-space delimited form. I put them

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

Can anyone tell me what's wrong with this command?? xx<-subset(x,LOCAL.NAME==c("Chifumbata","Chikota"),select=c(13,16,19,23,26,2 9,30,33:48)) Warning message: longer object length is not a multiple of shorter object length in: LOCAL.NAME == c("Chifumbata", "Chikota") both of the following commands work fine

Dear Users, I use Sgeostat to calculate co variogram (function est.variogram with two variables). If i inverse the 2 variables in the functions, the co variogram change! Normaly it is symmetric, isn't it? Someone could me explain why, or give me an idea to calculate co variogram in a easy way... Thanks in advance Laurent ps : sorry for my english Laurent William Dubroca Centre de

I am just learning to use R. The data from my current project are integer-valued. I am able to create scatterplots, but I would like to have some indication on the plots when multiple data points overlap at the same x-y coordinate. SPSS uses 'petals', and other packages use jitter. Are there similar options in R? I have not been able to find any in the documentation. Thanks very much,

Hello Cracks, we want to import 10 x 365 files containing each 7 variables with 1211 rows. The filenames end with numbers from 1 to 365. We tried a for loop to import using read.table but we couldn't create the r objects within the loop. We want each file in an own r-objekt (matrix). Does anyone know what can be done? Thanks, Felix -- Felix Tiefenbacher Eidg. Institut f?r Schnee- und