Displaying 3 results from an estimated 3 matches for "atmpt".
Did you mean:
atempt
2009 Dec 29
3
error logging
...bose DBI errors as they come up (to standard
output), but I'd like to trap and log them to a file as I running about
3000000 sql statements through this particular piece of code and I'd like to
keep the loop going and deal with all the errors once the bulk of it has
been processed.
atmpt <- try(dbGetQuery(con,sql))
options(show.error.messages = TRUE)
if(inherits(atmpt, "try-error")){
}
The R docs aren't structured in the way I'm used to(I will get the hang of
it)... so I'm more than willing to ?theDesiredCommand at the R - prompt.....
2009 Dec 21
2
Closing files after using write
When I run the following code in a loop I get an error after about 125 times
saying too many open files...
if(inherits(atmpt, "try-error")){
output <- paste(yahooSymbol,"\n",sep="")
write(output, file = "data", append = TRUE, sep = "")
} else {
I've tried various things to close the file after write opens it, and looked
through the RBase d...
2009 Dec 30
1
seg-fault... but on what
...39;",as.character(fileLines[j,1]),"','",fileLines[j,3],"','",fileLines[j,4],"','",fileLines[j
,5],"','",fileLines[j,6],"','",fileLines[j,7],"')",sep="")
#print(sql)
atmpt <- try(dbGetQuery(con,sql))
options(show.error.messages = TRUE)
if(inherits(atmpt, "try-error")){
}
}
}
dbDisconnect(con)
My understanding was that in general R liked to put a placekeeper like NA or
NULL in for non-existent elements of defined structure...