Displaying 1 result from an estimated 1 matches for "experimentset".
Did you mean:
experimentsets
2009 Jan 30
1
run query using rexcel runrfile and rodbc sql query
...RODBC")
query <- function(qu){
con <-
odbcConnect
("Development
",uid="username",pwd="password",believeNRows=FALSE,rows_at_time=50)
sqlQuery(con,qu)
}
qu <- paste("m.parentid as SET from setmap m where m.childid in
(select t.experiment from experimentsets t where
t.setname='",inSET,"')",sep="")
ExperimentSet <- as.character(query(qu)[,1])
The error only occurs when I call my "query" function. Does anyone
know if there is a way to run sql queries in this manner?