[R-sig-DB] RMySQL problem with dbWriteTable

[David James]

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