similar to: S/R/RWeb/ODBC

I am trying to develop an interactive software and would like to know how I can hook up R to the web. Thanks Joe Warfield

Hello, I'm having difficulty passing an object name to a lapply function. Can somebody tell me the trick to make this work? #Works T13702 <- TRACKDATA[["13702.xls"]][["data"]] min(unlist(lapply(list(T13702), function(x) mdy.date(x[1, 2], x[1, 1], x[1, 3])))) 16553 #Works d<-2 assign(paste("T",substr(names(TRACKDATA)[d],1,(nchar(names(TRACKDATA)[d]

You can test if the problem is accumulation in memory registers, which is certainly what this sounds like. Just do a loop over a reasonably small number of iterations and store or print the time between each iteration. If memory accumulation it will run optimally for the first few iterations, after which the time will increase noticeably (essentially exponentially, hence ultimately freezes up). If

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

When I am connecting to the server via ODBC I got the following error. >library(RODBC) channel <- odbcConnect("my server", uid="***" , case="*****") Error in switch(case, toupper = case <- 1L, tolower = case <- 2L, postgresql = case <- 2L, : Invalid case parameter: nochange | toupper | tolower | common db names How to fix this error? Thanks --

Hi, How are you? I have a quick question.... I have code that works perfectly with R desktop, but does not work with RWeb. Could you please tell me how to modify the code below so it will work with RWeb? #Read in txt file happyguys<-read.table("c:/test8.txt", header=TRUE, row.names=1) #Subset the txt file to only include certain values test<-subset(happyguys, GRADE == 7

I cannot discover how to set or find the working directory in Rweb, so that I can source() a file from the server. The file I source() must refer to a data file in its directory. setwd() does not do anything, and getwd() says that the working directory is in /var/www/cgi-bin/ (on Linux). (I have a student who installed R on her own computer and analyzed half of her data, and then her computer

Hi, I got this working. i had to get rid of an underscore in one of my variable names to work on RWeb. Thanks for your help though!! Natalie __________________ I think you have to be either honest or careful, since the code you submitted to Rweb is different with your former code! Why the condition was changed from "test<-subset(X, GRADE == 7 & Y_Q10A < 9)" to

Hi, RWeb web site is down past couple days, I am insterested in this project and want to try it for my projects. Deos anyone have this installation and user guide? Thanks! Best Regards, WeiQiang Li

Greetings, I am working on creating an interactive website that will generate R-code for users based in the information they input on the site. Currently, the R-code can be generated and downloaded to be run locally on a computer with R. However, I have noticed a number of applications out there that instead submit the code directly to an R-web server. Some examples seem to be:

Hi folks, Could you tell me (a) good newsgroup/s or mailing lists concerning (1) Rweb in general (2) Rweb and Java, please. Cheers, Michael Wisnewski -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the

Hello, I successfully used RODBC very frequently, but after having updatetd to R 6.0.2, the current RODBC-Version gives me some problems. After connecting to my Oracle-Database via odbcConnect("") (or the necessary information) I receive a much longer output than usual: RODB Connection 0 Details: case=nochange DRIVER={Oracle in OraHome90} ... with all the details. Previously,

Happy New Year to all in the list! I am trying to issue an SQL query to a database from R using RODBC (on Windows). The data source file is on my PC hard disk : C:\Program Files\ODBC\sql.dsn The "\" character does not get interpreted properly in R - it is removed from the file-spec string or if I specify "\\" it appears as such with a syntax error in odbcConnect(dsn,

Hi I am trying to use RODBC in R installed on Windows to access MySQL database (on a linux box). I set up a DSN and specified this DSN in R as follows library(RODBC); channel <- odbcConnect("mysqldsn"); RODB Connection 5 Details: case=nochange PORT=3306 ........ Although this seems to connect properly, running any command yields NO results. i.e. sqlQuery(channel, "show

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Hello list: I have some R code/data sets that i'd like to make available to others through RWeb server use.  The code/data were saved via "save.image" and should be made available by the following command sequence: con <- url("https:// ....") load(con) close(con) However, this is where the problem starts... For one thing, i am using google docs to host the R object

Hello, Might anyone know how to conduct Wald-type F-tests of the fixed effects estimated by glmmPQL? I see this implemented in SAS (GLIMMIX), and have seen it recommended in user group discussions, but haven't come across any code to accomplish it. I understand the anova function treats a glmmPQL fit as an lme fit, with the test assumptions based on maximum likelihood, which is inappropriate

Hello, I'm working with a package that uses download.file in functions to extract information from remote databases. My current environment is Windows XP Pro SP3, R 2.7. A full extraction can be a great deal of data, so the download is accomplished in generally manageable packets, such that a single download will result in many files, which are written to a directory. It is not uncommon for a

Full_Name: Jeff Lindon Version: 2.5.0 OS: mingw32 Submission from: (NULL) (63.147.8.67) R 2.5.0 seems to be unable to read valid tables from SQL Server 2005 with Service Pack 2 installed: > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386,