search for: dbconn

..."B", "A", "C","C") each of which have an id in a table in my db. I need to convert the names to their corresponding ids. I currently have the following code to do it. ### names<-c("A", "B", "A", "C","C") dbConn<-odbcDriverConnect(connection="connection string") #successfully connects nameToID<-function(name, dbConn){ #dbConn : active db connection formed via odbcDriverConnect #name : a char string sqlQuery(dbConn, paste("select id...

I am having the following problem with RODBC I connect to an oracle 8i (8.1.7) database using RODBC as follows; dbConn <- odbcConnect("mydatabase","myuserid","mypassword",case="oracle") Then I extract some data, actually a whole table; orgdata <- sqlQuery(dbConn, "select * from organism", na.strings = "NA") Then I try to save it back; sqlSave(dbConn...

...om mddsg100bp txn inner join mdd_panfvs pan on (txn.seq_no = pan.seq_no) inner join mdd_mccfvs mcc on (txn.seq_no = mcc.seq_no) inner join mdd_tmzipfvs tmzip on (txn.seq_no = tmzip.seq_no) where is_test = '%d' and is_pos = '%d' and ora_hash(txn.seq_no,%d,%d)=0" dbConn = odbcConnect("mysid",uid="myuser",pwd="mypass",case="toupper",believeNRows=FALSE) tfg = sqlQuery(dbConn, sprintf(sqlTxnFvs,0,0,1/sratg-1,seeds[i])) dbErr = odbcGetErrMsg(dbConn) All of the tables except mddsg100bp are IOT tables (index organized tables aka...

I have a dump of some tables to be filled when the app is setup ''.../db/dataset/regions_dpt_cities_codes.sql'' I would like to execute a task similar to the >mysql source <dump_file> like : ActiveRecord::Base.connection.execute("source #{path};") (which doesn''t run fine, of course.... is it possible in a rake task ? if yes, any suggestion ?

How does Action Mailer perform when sending out say 3,000 emails? I know the answer will have a lot to do with the hardware, but in general, is Action Mailer up to the task of completing an operation like this in reasonable time?