[R-sig-DB] RMySQL problem with dbWriteTable
David James
dj @end|ng |rom re@e@rch@be||-|@b@@com
Fri Jun 23 20:49:42 CEST 2006
Hello,
Could you tell us what versions of MySQL (both client and server),
R and RMySQL you're using? E.g.,
> summary(con, TRUE)
<MySQLConnection:(14386,2)>
User: dj
Host: gaia
Dbname: rsdbdi
Connection type: tukey via TCP/IP
MySQL server version: 4.1.15-standard
MySQL client version: 4.1.7
MySQL protocol version: 10
MySQL server thread id: 160
No resultSet available
--
David
kaustubh shinde wrote:
> Hi,
> I am working with R and MySQL using RMySQL package.
> I am trying to write to a table in the database using
> dbWriteTable(mycon1, "DoubleProperty", frame, append = T,row.names=F)
> and I am getting error
> Error in mysqlWriteTable(conn, name, value, ...) : unimplemented type 'character' in 'asLogical'
> I had this error before and then I just wrote a separate function that took a dataframe as parameter and wrote it to DB using the above code.
> The error did not make any sense to me then and it's not making any now. Using the same approach is not doing it for me now.
> The connections are properly opened and closed and the dataframe is also good.
>
> Here is what I am trying to do
>
> ibmtse<-as.data.frame(ibmtse)put(ibmtse)
>
> put<-function(frame){mycon1 <- dbConnect(MySQL(), user='***', dbname=db, host="******", password='******')dbWriteTable(mycon1, "DoubleProperty", frame, append = T,row.names=F)print("Data written")dbDisconnect(mycon1)}Any ideas on this would be really appreciated as I have absolutely no clue.
> Thank you,
> Kaustubh
> _________________________________________________________________
> Add photos, news, and blogs about the World Cup to your Live.com homepage!
> http://www.live.com/getstarted
> [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
More information about the R-sig-DB
mailing list