Displaying 18 results from an estimated 18 matches for "sqliteexecstatement".
2012 May 09
2
Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:
...POSIXt"))), .Names = c("NAME", "TMSTMP",
"PRICE", "DATE", "DTTM"), row.names = c(NA, 6L), class = "data.frame")
I run the above command again but this time I get an error:
> new3 = sqldf("select * from testeq")
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: no such table: testeq)
In addition: Warning message:
In value[[3L]](cond) : RAW() can only be applied to a 'raw', not a 'double'
Can anyone guide me if there is any difference in the structure of the two
dataframes...
2013 Jan 15
1
SQLDF column errors
...rd1580
15987 rd1590
16222 rd2020.....
df1_new<-sqldf("select df1.V1, df2.V2 where rs10.V1 = d10.pos”) - Ideally I
would like to try to use "delete" or not equal to "!=" though I can only
find that delete works with sqldf.
but it returns this error:
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: no such column: df1.V1)
I am also trying this:
df1_new<-sqldf("select V1 from df1, V2 from df2 where df1.V1 = df2.V1")
which returns this error:
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver:...
2008 Sep 15
2
S4 coercion responsibility
...QLite")
> con <- dbConnect(m)
> setClass("SQLConPlus", contains=c("SQLiteConnection","integer"))
[1] "SQLConPlus"
> conPlus <- new("SQLConPlus", con, 1)
> dbListTables(con)
character(0)
> dbListTables(conPlus)
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (invalid dbManager handle)
> dbListTables(as(conPlus, "SQLiteConnection"))
character(0)
>
The problem is happening in sqliteExecStatement which does
conId <- as(con, "integer")
but con only *contains* an SQLiteConnectio...
2012 Nov 23
3
read.csv.sql() to select from a large csv file
...a
time, for example "Bobby".
read.csv.sql("filename",sql = 'select * from file where ID = “Bobby”') works fine, but
Name <- "Bobby"
read.csv.sql("filename",sql = 'select * from file
where ID = Name') gives me an error message
“Error in sqliteExecStatement(con, statement,
bind.data) :
RS-DBI driver: (error in statement: no such column: Name)”
I would like to use a variable in the select statement because I have many individuals in the original csv file, is this possible ? I have no experience with sql, perhaps someone can kindly point out how to d...
2010 Sep 06
3
Failure to aggregate
I have a (very big - 1.5 rows) dataframe with a (POSIXt" "POSIXlt") column h
(hour). Surprisingly, I cannot calculate a simple aggregate over the
dataframe.
> n.h1 = sqldf("select distinct h, count(*) from x group by h")
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: no such table: x)
In addition: Warning message:
In value[[3L]](cond) : RAW() can only be applied to a 'raw', not a 'double'
> n.h2 = aggregate(x$price, by = x$h, FUN = nrow)
Error in names(y) <- c(names(by),...
2010 Jan 25
3
question on sqldf syntax
...dbs.final <- sqldf("select dbs.possible.combos$Date,
dbs.possible.combos$Place, dbs.possible.combos$Days FROM dbs.possible.combos
LEFT JOIN dbs.aggregate ON (dbs.possible.combos$Place = dbs.aggregate$Place)
AND (dbs.possible.combos$Date = dbs.aggregate$Date)")
Resulting in:
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near ".": syntax error)
What am I getting wrong in the syntax?
--
View this message in context: http://n4.nabble.com/question-on-sqldf-syntax-tp1289707p1289707.html
Sent from the R help mailing list archive at...
2004 Nov 25
3
Searching for a string in RSQLite
...g 6.8 161 60 15.6
# Buf if the search string contains characters that SQL interprets, I
# get an error
> state <- "messy: ' ("
> dbGetQuery(con, paste("SELECT * from USArrests where row_names='",state,"'",sep=""))
Error in sqliteExecStatement(con, statement) :
RS-DBI driver: (error in statement: near "(": syntax error)
Duncan Murdoch
2008 Apr 03
2
sqldf file specification, non-ASCII
...> f <- file("hugedata.csv")
> DF <- sqldf("select * from f where C_OPR like 'KKA2%'",
file.format=list(header=T, row.names=F))
Error in try({ :
RS-DBI driver: (RS_sqlite_import: hugedata.csv line 1562740 expected
52 columns of data but found 19)
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: no such table: f)
Now, I know that my SAS-using colleagues are able to use this file with
SAS, so I was wondering whether StatTransfer'ing it to the SAS XPORT
format which can be read with the 'read.xport' function in...
2008 May 12
1
Insert a recorde into a table using SQL
...QLite"),":memory:")
> dbWriteTable(con,"dd",dd,over=T)
[1] TRUE
> dbGetQuery(con,sprintf("insert into dd (txt) values (\"%s\")",dd[2,1]))
NULL
> dbGetQuery(con,sprintf("insert into dd (txt) values (\"%s\")",dd[1,1]))
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: unrecognized token: "")")
How can I insert a (key, value) pair into a table by dbGetQuery? Thanks.
--
HUANG Ronggui, Wincent
Bachelor of Social Work, Fudan University, China
Master of sociology, Fudan University,...
2010 Jul 20
1
Error using sqldf
...ta2,
events.`timestamp` as tobiiTime
FROM tobiiEvents
INNER JOIN events ON events.eventid = tobiiEvents.eventid
WHERE tobiiEvents.subtype = 'MOUSE' AND tobiiEvents.userid = $userid AND
tobiiEvents.taskid = $taskid
ORDER BY events.`timestamp`")
it gives me following error:-
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near "(": syntax error)
Can you guys suggest me where I am going wrong in passing in variable to
sqldf() query.
Thanks in advance.
Harsh Yadav
[[alternative HTML version deleted]]
2010 Aug 26
1
sqldf syntax
Please correct the following
> sqldf("update esc left join forwagg on esc.ym=forwagg.Date set esc.ri2=forwagg.N1 where esc.age=12","select * from main.esc")
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near "left": syntax error)
Thanks.
Stephen
[[alternative HTML version deleted]]
2011 Apr 18
2
SQLDF syntax
...th columns commodity, rate and total and I am trying
to create new table called DataNew with columns commodity, ratenew and
totalNew.
> sqldf("create table datanew as select commodity, ratenew as rate * 10,
> totalnew as total *10 from DataOld")
I got error message " Error in sqliteExecStatement(con, statement,
bind.data) :
RS-DBI driver: (error in statement: near "*": syntax error)
Please help me in this regard.
Thank you
--
View this message in context: http://r.789695.n4.nabble.com/SQLDF-syntax-tp3458919p3458919.html
Sent from the R help mailing list archive at Nabble....
2012 Mar 21
1
Using extract function for dates in sqldf
...a given year. My query looks like this:
test11 <- sqldf("select CHILD_ID, min(SAMP_DATE)
from lab
group by CHILD_ID
having extract (year from SAMP_DATE) = 2011")
SAMP_DATE has class "date." I get the error message
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near "from": syntax error)
The problem seems to be in the second "from" where the "extract" function
is called. Does this need a fix or am I doing something wrong?
Thanks in advance and apologies if...
2013 Feb 12
0
How do I solve a disk I/O error with RSQLite?
...etQuery(sql.dispersion,
+ "create table monthly_data_temp as
+ select a.*, b.industry
+ from monthly_data as a left join
+ siccd_industry_ff49 as b
+ on a.siccd = b.siccd
+ order by permno, date")
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (RS_SQLite_exec: could not execute1: disk I/O error)
Calls: dbGetQuery ... dbGetQuery -> sqliteQuickSQL ->
sqliteExecStatement -> .Call
Execution halted
I ran the same code by using sqlite3 from the command line and had no error.
$ sqlite3 di...
2010 Aug 27
1
Error: package/namespace load failed for 'IlluminaHumanMethylation27k.db'
...te()'. To cite Bioconductor, see
'citation("Biobase")' and for packages 'citation(pkgname)'.
Loading required package: org.Hs.eg.db
Loading required package: DBI
Error : .onLoad failed in loadNamespace() for
'IlluminaHumanMethylation27k.db', details:
call: sqliteExecStatement(con, statement, bind.data)
error: RS-DBI driver: (error in statement: near "s": syntax error)
Error: package/namespace load failed for 'IlluminaHumanMethylation27k.db'
I have tried the following things:
- I reinstalled the packages from Bioconductor (AnnotationDbi, Biobase,
o...
2013 Jul 15
2
Serialize data.frame to database
...tried to use the ASCII format
data.ascii <- serialize(iris, NULL, ascii = TRUE)
data.raw <- rawToChar(data.ascii)
dbSendQuery(db, "DELETE FROM frames")
dbSendQuery(db, paste("INSERT INTO frames VALUES(1, X'", data.raw, "')", sep = ""))
Error in sqliteExecStatement(conn, statement, ...) :
RS-DBI driver: (error in statement: unrecognized token: "X'A
This also does not work. It seems the driver does not deal that nicely with the regular INSERT query for BLOB objects in SQLite. Then I used a simpler way:
dbSendQuery(db, "DELETE FROM frames"...
2012 Jun 29
0
Problem on loading annotation for BioC - error: RS-DBI driver: (error in statement: near "s": syntax error)
...te Bioconductor, see
'citation("Biobase")', and for packages 'citation("pkgname")'.
Loading required package: org.Hs.eg.db
Loading required package: DBI
Error : .onLoad failed in loadNamespace() for
'hugene10sttranscriptcluster.db', details:
call: sqliteExecStatement(con, statement, bind.data)
error: RS-DBI driver: (error in statement: near "s": syntax error)
--
View this message in context: http://r.789695.n4.nabble.com/Problem-on-loading-annotation-for-BioC-error-RS-DBI-driver-error-in-statement-near-s-syntax-error-tp4634860.html
Sent from the R...
2007 Nov 10
7
How to more efficently read in a big matrix
Dear list,
I need to read in a big table with 487 columns and 238,305 rows (row names
and column names are supplied). Is there a code to read in the table in
a fast way? I tried the read.table() but it seems that it takes forever :(
Thanks a lot!
Best,
Allen