search for: dbdatatype

Displaying 10 results from an estimated 10 matches for "dbdatatype".

Did you mean: datatype
2007 Mar 20
1
RMySQL load error
...ot;fetch" [1] "dbGetInfo" [1] "dbGetStatement" [1] "dbListFields" [1] "dbColumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException" [1] "summary" [1] "dbDataType" [1] "make.db.names" [1] "SQLKeywords" [1] "isSQLKeyword" [1] "dbApply" [1] "dbApply" ** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL...
2005 Mar 09
1
RMySQL installed but not availalable
...quot; > [1] "dbGetStatement" > [1] "dbListFields" > [1] "dbColumnInfo" > [1] "dbGetRowsAffected" > [1] "dbGetRowCount" > [1] "dbHasCompleted" > [1] "dbGetException" > [1] "summary" > [1] "dbDataType" > [1] "make.db.names" > [1] "SQLKeywords" > [1] "isSQLKeyword" > [1] "dbApply" > [1] "dbApply" > > ** help > >>> Building/Updating help pages for package 'RMySQL' > Formats: text html latex ex...
2002 Dec 18
1
A little problem handling logicals in RMySQL under R1.6.1
...Connection:(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 <- sapply(a, dbDataType, dbObj = con) > field.types x y "tinyint" "tinyint" # However, in WriteTable, nothing is done to convert the logicals to 0s and 1s. # And logically, the infile is written in TRUE and FALSE and finally, in MySQL # all becomes zero. Here is what we get in...
2005 Oct 27
2
RSQLite problems
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
2007 Dec 21
0
RMySQL installation
...example dbBuildTableDefinition text html latex dbCallProc-methods text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example Note: unmatched right brace in 'dbDataType-methods' on or after line 24 dbDataType-methods text html latex example dbDriver-methods text html latex example dbEscapeStrings-methods text html latex example dbEscapeStrings text html latex...
2011 Dec 01
0
RSQLite 0.11.0
A new version of RSQLite has been uploaded to CRAN. Details on the enhancements and fixes are below. Please direct questions to the R-sig-db mailing list. Version 0.11.0 - Enhance type detection in sqliteDataType (dbDataType). The storage mode of a data.frame column is now used as part of the type detection. Prior to this patch, all vectors with class other than numeric or logical were mapped to a TEXT column. This patch uses the output of storage.mode to map to integer and double vectors to INTEGER and REAL...
2011 Dec 01
0
RSQLite 0.11.0
A new version of RSQLite has been uploaded to CRAN. Details on the enhancements and fixes are below. Please direct questions to the R-sig-db mailing list. Version 0.11.0 - Enhance type detection in sqliteDataType (dbDataType). The storage mode of a data.frame column is now used as part of the type detection. Prior to this patch, all vectors with class other than numeric or logical were mapped to a TEXT column. This patch uses the output of storage.mode to map to integer and double vectors to INTEGER and REAL...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...t; [1] "fetch" [1] "dbGetInfo" [1] "dbGetStatement" [1] "dbListFields" [1] "dbColumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException" [1] "summary" [1] "dbDataType" [1] "make.db.names" [1] "SQLKeywords" [1] "isSQLKeyword" [1] "dbApply" [1] "dbApply" ** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL...
2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
...text html latex example S4R text html latex dbCallProc-methods text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example dbDataType-methods text html latex example dbDriver-methods text html latex example dbGetInfo-methods text html latex example dbListTables-methods text html latex example dbObjectId-class text...
2002 Oct 16
5
Database newbee problem...
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