search for: tblname

...for ( i in 1:2 ) { # 1. Weekly 2. Monthly if (i == 1) { bWeekly <- TRUE } else { bWeekly <- FALSE } # Get Prices if ( bWeekly ) { tblName <- "qryDataWeekly_Crosstab" } else { tblName <- "qryDataMonthly_Crosstab" } prices <- sqlFetch(channel, tblName, colnames = FALSE, rownames = TRUE) # Get Weightings sql <- &q...

...m8 m9 m10 m11 q q2 msr icr fb1 fd8 msf ids) # } # execute the x12 fortran pgm. executable x12a stored in /home/fred/x12a system("/home/fred/x12a/x12a blp") # read x12 fortran pgm output tables back into R blp.x12 <- readx12out("blp", adtype="M", calendar=F, tblnames=NULL) # basic versions of writex12in and readx12out writex12in <- function(tso,file){ write.table(cbind(time(tso) %/% 1, cycle(tso), tso), file=paste(file,".dat",sep=""), sep=" ", quote=F, row.names=F, col.names=F) } readx12ou...

I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is

...ySQL which deals with it, or is my on;ly option to switch to RODBC (which I would not like to do as I am using Linux)? If I have to use RODBC, how can I easily adapt the follolwing code? Thanks Rainer > m <- dbDriver("MySQL") > conn <- dbConnect(m, group = "test") tblname <- "dummy" > dat <- data.frame(n1=runif(10), n2=runif(10)) > dbWriteTable( conn, tblName, dat, overwrite=FALSE, append=TRUE ) Error in field.types$row.names : $ operator is invalid for a...

I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME. Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values. Can this be done? If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an

...#39;toupper' or 'tolower'. I am trying to be cleaver[1] and make a flexible data structure in R. I have a relatively large quantity of data that can be broadly grouped into blocks/chunks which are identical in their form: blockid = numeric blocktype = string dbname = string tblname = string quality = numeric errortype = numeric columnamount = data vector distr = data vector ... I have grouped the above into a list as it contains mixed variable types. Now is where things get a little more interesting... I have a large number of the above blocks which I would like t...

...rce code block further down in the same file, and it can read in the data in the table. Then you can go back to the table to edit, then rerun R, ... I append an example below. There is a load of tutorial info at http://orgmode.org/worg/org-tutorials/index.php HTH, Chuck #+begin_example #+tblname: simpleDF | a | b | c | |---+---+---| | 1 | 2 | 3 | | 5 | 4 | 2 | |---+---+---| #+end_example #+begin_src R :var df=simpleDF :results output :colnames yes summary( df ) #+end_src #+results: : a b c : Min. :1 Min. :2.0 Min. :2.00 : 1st Qu.:2 1st Qu....