I've tried to upgrade to latest (?) http://cran.mtu.edu/bin/windows/contrib/2.12/RODBC_1.3-3.zip , but no luck. It looks like nothing is being escaped as I tried to use character class, but I got same error message.
Mikhail > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf Of Mikhail Titov > Sent: Sunday, August 07, 2011 7:27 PM > To: r-help@r-project.org > Subject: Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field? > > I apologize for the first e-mail as I didn't use plain text. Here is the > full message. > --8<----------------------------------------------------------------------- > - > ------>8-- > > Hello all! > > Can someone confirm whether there is a bug or not? > > I was trying to use sqlUpdate in place of sqlSave as data set I import has > duplications. However I get errors while using fast=FALSE argument to > safely > update/ignore duplicates: > > Error while executing the query[RODBC] ERROR: Could not SQLExecDirect > 'UPDATE "data" SET "logger"=1, "value"=0.0321584 WHERE "time"=2008-09-22 > 13:15:00' > Error in sqlUpdate(con2, na.omit(dat), "data", fast = FALSE) : > 42601 7 ERROR: syntax error at or near "13"; > > It looks like POSIXct class is not escaped properly. > > I have R 2.12.2 running on Windows XP 32 bit, and I’m using PostgreSQL > database. Column time is supposedly of ‘timestamp without time zone’. > > Here is what I have in the data frame I’m pushing to DB: > > > class(dat$time) > [1] "POSIXct" "POSIXt" > > Mikhail > > > -----Original Message----- > > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] > On > > Behalf Of Mikhail Titov > > Sent: Sunday, August 07, 2011 7:22 PM > > To: r-help@r-project.org > > Subject: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field? > > > > Hello all! > > > > > > > > Can someone confirm whether there is a bug or not? > > > > > > > > I was trying to use sqlUpdate in place of sqlSave as data set I import > has > > duplications. However I get errors while using fast=FALSE argument to > > safely update/ignore duplicates: > > > > > > > > Error while executing the query[RODBC] ERROR: Could not SQLExecDirect > > 'UPDATE "data" SET "logger"=1, "value"=0.0321584 WHERE "time"=2008-09-22 > > 13:15:00' > > > > Error in sqlUpdate(con2, na.omit(dat), "data", fast = FALSE) : > > > > 42601 7 ERROR: syntax error at or near "13"; > > > > > > > > It looks like POSIXct class is not escaped properly. > > > > > > > > I have R 2.12.2 running on Windows XP 32 bit, and Ib > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting- > guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
