search for: coltypes

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

...u) "2004-01-05" (M) "2004-01-06" (Tu) "2004-01-07" (W) "2004-01-08" (Th) The codes are (also attached): rm(list=ls()) library(XLConnect) library(xlsx) fl<-paste("allData_out3.xlsx") a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") a_col<-readWorksheetFromFile(fl, sheet="first") date11<-as.Date(a_col$date, format="%Y-%m-%d") The output: > date11 [1] "2003-12-31" "2004-01-...

development.log contains quite a few SELECTS on system tables like COLUMNS. Wouldn''t it be more efficient to cache this info? I''m also wondering about strings like "[4;35;1m". What''s their purpose and is it possible to get rid of them? They look like screen coordinates and makes no sense in a text file. Christer Processing ReportController#create (for

...quot;2004-01-07" (W) > "2004-01-08" (Th) > > > > The codes are (also attached): > > > rm(list=ls()) > library(XLConnect) > library(xlsx) > > fl<-paste("allData_out3.xlsx") > a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") > b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") > a_col<-readWorksheetFromFile(fl, sheet="first") > date11<-as.Date(a_col$date, format="%Y-%m-%d") > > > The output: >> date11 > [1]...

...> > > > > > > > The codes are (also attached): > > > > > > rm(list=ls()) > > library(XLConnect) > > library(xlsx) > > > > fl<-paste("allData_out3.xlsx") > > a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") > > b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") > > a_col<-readWorksheetFromFile(fl, sheet="first") > > date11<-as.Date(a_col$date, format="%Y-%m-%d") > > > > > > The outp...

...ched): > >>> > >>> > >>> rm(list=ls()) > >>> library(XLConnect) > >>> library(xlsx) > >>> > >>> fl<-paste("allData_out3.xlsx") > >>> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") > >>> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") > >>> a_col<-readWorksheetFromFile(fl, sheet="first") > >>> date11<-as.Date(a_col$date, format="%Y-%m-%d") > >>&...

...>>> The codes are (also attached): >>> >>> >>> rm(list=ls()) >>> library(XLConnect) >>> library(xlsx) >>> >>> fl<-paste("allData_out3.xlsx") >>> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") >>> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") >>> a_col<-readWorksheetFromFile(fl, sheet="first") >>> date11<-as.Date(a_col$date, format="%Y-%m-%d") >>> >>> &...

...numeric). Here is my code (the Excel file is attached): rm(list=ls(all=TRUE)) library(XLConnect) tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) set <- readWorksheet(tab, sheet = "settings") setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") index <- which((!is.na(setNum)), arr.ind=TRUE) if(length(index)!=0){ set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.character(x)))) } ## to check set[10,1] ## Problem: must be numeric !!!! writeWorksheetToFile("C:/Users/Downloads/Test.xlsx"...

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

Hi, I have a dataset consisting of 350,000 rows and 266 columns. Out of 266 columns 250 are dummy variable columns. I am trying to read this data set into R dataframe object but unable to do it due to memory size limitations (object size created is too large to handle in R). Is there a way to handle such a large dataset in R. My PC has 1GB of RAM, and 55 GB harddisk space running

...;> >>> >> >>> rm(list=ls()) >> >>> library(XLConnect) >> >>> library(xlsx) >> >>> >> >>> fl<-paste("allData_out3.xlsx") >> >>> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric") >> >>> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric") >> >>> a_col<-readWorksheetFromFile(fl, sheet="first") >> >>> date11<-as.Date(a_col$date, format="%Y-%m-%d") &g...

Commit b91b39e06ab7eb9b9b06c8b4dfef2ef9f381ab19 changed the separator to ':', although this creates parsing issues when there are fields with colons (for example lv_tags=imgbased:pool). Change once more the separator, but this time using a non-printable character such as '\r': while it will produce uglier debug logs, this should greatly reduce the possibilities of conflicts with

...sion of ".txt". > > rm(list=ls(all=TRUE)) > library(XLConnect) > tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) > set <- readWorksheet(tab, sheet = "settings") > setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") Presumably you could also send the results of dput(setNum) .. either as a .txt attachment or embedded in an email. > index <- which((!is.na(setNum)), arr.ind=TRUE) > if(length(index)!=0){ > set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.c...

Dear Listers: I have a couple of data frames to report and each corresponds to different condtions, e.g. conditions=c(10, 15, 20, 25). In this examples, four data frames need to be exported in a "pretty" report. I knew Perl has some module for exporting data to Excel and after googling, I found R does not. So I am wondering if there is a package in R for generating good reports. I

Hi, I have a medium-sized (19MB) CSV file that I'd like to read into R. The read.csv() function seems to be a bit inefficient to deal with it, and I remember that using scan() with "what" options is better. However I'm unable to understand how to use it. The first few lines of the data look like:

...ension of ".txt". > > rm(list=ls(all=TRUE)) > library(XLConnect) > tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) > set <- readWorksheet(tab, sheet = "settings") > setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") Presumably you could also send the results of dput(setNum) .. either as a .txt attachment or embedded in an email. > index <- which((!is.na(setNum)), arr.ind=TRUE) > if(length(index)!=0){ > set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.ch...

The separator character (currently comma) was picked arbitrarily to allow us to parse the output of commands like 'lvs' for APIs such as 'lvs-full'. Unfortunately the choice of comma conflicts with the 'lvs -o modules' column, since the list of modules is separated by commas, breaking our parser. Change the separator to another arbitrary character (colon) which hopefully

Hi, I'm working in R 2.11.1 x64 on Windows x86_64-pc-mingw32. I'm trying to insert a very large CSV file into a SQLite database. I'm pretty new to working with databases in R, so I apologize if I'm overlooking something obvious here. I'm trying to work with the American Community Survey data, which is two 1.3GB csv files. I have enough RAM to read one of them into memory,

Hi, Attached are two datasheet to be read. My raw data "130502temp.xlsx" contains numbers with ' symbols, and they can't be read as numbers. Even if I copy and paste as numbers to form a new file "130502temp_number1.xlsx", they could not be read smoothly. 1. How can I read the datasheet as numbers? 2. How can I treat the notation "-" as (1)

I am unable to get ActiveRecord session support to work under 2.x against a SQL Server database. I''m starting to wonder if anyone is running 2.x against SQL Server? Is anyone running under the following configuration: Rails 2.x SQL Server 2000 DB (using AR adapter in ODBC mode) AR store for ActionController session store. I''d like to chat with you if you are. Thanks, Wes --