[R] Error while conecting to database.
Manish Gupta
mandecent.gupta at gmail.com
Thu May 24 09:11:54 CEST 2012
Hi,
I am getting following error message while retrieving records from mysql.
*Error in if (count > 0L) { : missing value where TRUE/FALSE needed
Calls: <Anonymous> -> do.call -> <Anonymous> -> <Anonymous>
Execution halted*
con2 <- dbConnect(MySQL(), user="XXX", password="",dbname="yyyy",
host="XXX.X.X.X")
#if(nchar(disname) == 2)
{
disQuery= "select Desc from Tablename where Tableanem.field = "
cat(paste("*********",disname,"*************","\n",sep=""))
disQuery<-paste(disQuery, "'", disname ,"'", sep = "")
cat(disQuery,"\n")
cat(paste("\\textbf{",Col3[i],"?}\n",sep=""))
cat("\\leavevmode","\n")
cat("\\newline","\n")
#cat(disQuery,"\n")
#print(dbListTables(con2))
disres <- dbSendQuery(con2, disQuery)
dout <- fetch(disres, n = 10000)
dataout <- ifelse(is.na(dout), "-" ,dout)
cat(paste(dataout),"\n") * // getting error
message here*
}
dbDisconnect(con2)
May i know why I am getting above error message.
Regards
--
View this message in context: http://r.789695.n4.nabble.com/Error-while-conecting-to-database-tp4631169.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list