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