[R] Query about data manipulation

2007-03-01 Thread lalitha viswanath
Hi Thanks much for the prompt response to my earlier enquiry on packages for regression analyses. Along the same topic(?), I have another question about which I could use some input. I am retreiving data from a MySQL database using RODBC. The table has many BLOB columns and each BLOB column has d

Re: [R] Query about data manipulation

2007-03-01 Thread Marc Schwartz
On Thu, 2007-03-01 at 08:34 -0800, lalitha viswanath wrote: > Hi > Thanks much for the prompt response to my earlier > enquiry on packages for regression analyses. > Along the same topic(?), I have another question about > which I could use some input. > > I am retreiving data from a MySQL databas

Re: [R] Query about data manipulation

2007-03-01 Thread jim holtman
[,3] [,4] [1,] "id1" "id2" "id3" "id4" [2,] "1" "2" "3" "4" [3,] "5" "6" "7" "8" > Jim Holtman "What is the problem you are trying to solve?"

Re: [R] Query about data manipulation

2007-03-01 Thread lalitha viswanath
Hi Thanks much for that input.It was extremely helpful. I am seeking some input about another stumbling block using RODBC; SQLQuery et al with large BLOB values. Although the following query dataFromDB <- sqlQuery(channel, "select uncompress(columnName) from tableName where Id=id "); returns jus

Re: [R] Query about data manipulation

2007-03-01 Thread Marc Schwartz
On Thu, 2007-03-01 at 12:35 -0800, lalitha viswanath wrote: > Hi > Thanks much for that input.It was extremely helpful. > > I am seeking some input about another stumbling block > using RODBC; SQLQuery et al with large BLOB values. > > Although the following query > dataFromDB <- sqlQuery(channe