search for: totalrows

...les) using RODBC. I have a column called "index" which is used to order rows. Unfortunately, sqlQuery can't return all the values from a column at once (RODBC complains about lack of memory). So I am using the following code: getcolumns <- function(channel, tablename, colnames, totalrows, ordered=TRUE,chunksize=1e5) { r <- matrix(double(0),totalrows,length(colnames)) for (i in 1:ceiling(totalrows/chunksize)) { cat(".") r[((i-1)*chunksize+1):(i*chunksize)] <- as.matrix( sqlQuery(channel, paste("SELECT", paste(colnames...

...make dput dump rownames and colnames on two separate lines, but i don't think it's possible. To give a specific example, instead of dput output like **new("big.matrix.descriptor" , description = structure(list(sharedType = "FileBacked", filename = "res", totalRows = 1528, totalCols = 53040, rowOffset = c(0, 1528), colOffset = c(0, 53040), nrow = 1528, ncol = 53040, rowNames = c("A", "AA", "RNT.A", "ADVA", "AAPL", "AAS", "ABFS", "ABM", "ABT", "ACI",...

...the rest working. Thanks a lot. John UC Berkeley Student Here's some links for thought http://www1.clearlight.com/~oakley/tcl/ http://tech.groups.yahoo.com/group/tcl_announce/message/298 Here is is some of my code. I think selectcommand is supposed to go in the tk2mclistbox() totalcols = 5 totalrows = 100 idb <- matrix(NA, nrow = totalrows, ncol = totalcols, dimnames = list(c(),c("Date","URL", "Title", "List Price", "Category"))) base <- tktoplevel() listings <- tkframe(parent = base) editor <- tkframe(parent = base) tkwm.title(ba...

Skipped content of type multipart/alternative-------------- next part -------------- Index: connection_adapters/abstract/connection_specification.rb =================================================================== --- connection_adapters/abstract/connection_specification.rb (revision 4617) +++ connection_adapters/abstract/connection_specification.rb (working copy) @@ -1,10 +1,21 @@ require

I''ve got a left join problem of some sort connecting from linux FreeTDS/ODBC to SQL Server. It''s similar to the false post I had earlier, but this is a real problem. Here''s my code: def find_recipes_for_workorder @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :joins => ''left join workorder on