search for: id01

...the list but was not able to apply them in my case... Is someone know how to do that? Below is my code with the expected result: # data frame 1 Id1 <- c(1,1,1,2,2,2,3,3,3) Habit1 <- c('a','a','a','b','b','b','d','d','d') Id01 <- paste(Id1, Habit1,sep=".") data1 <- data.frame(Id01) # data frame 2 Id2 <- c(1,2,3,3) Habit2 <- c('a','b','d','d') Id02 <- paste(Id2, Habit2,sep=".") Area <- c(10,2,3,5) data2 <- data.frame(cbind(Id02, Area)) # result tha...

...############################## #database connection mycon <- dbConnect(MySQL(), user='root',dbname='test',host='localhost',password='') #distinct sessions rsSessionsU01 <- dbSendQuery(mycon, "select distinct sessionID from actiontimes where userID = 'ID01'") sessionU01 <-fetch(rsSessionsU01) sessionU01[2,] #user01 data mycon <- dbConnect(MySQL(), user='root',dbname='test',host='localhost',password='') rsUser01 <- dbSendQuery(mycon, "select a.userID,a.sessionID,a.actionTaken,a.timelineMSEC,a.d...