Inline below. On Mon, Mar 21, 2011 at 8:18 AM, kellysong <song.q...@student.dit.ie> wrote: > Hi all, > > I am new user in R, I am trying to to use paste function to concatenate > strings which has been fetched from database table(postgres database), the > following are my code: > > when i do: > > sqlFetch(channel,'transactions') > > outputs are following(only parts, there are around 200 transactions in > total) > > orderid productname price quantity discount > 1 T10248 potato 1.80 10 0.00 > 2 T10248 sweets 2.00 5 0.00 > 3 T10249 milk 1.99 9 0.00 > 4 T10249 apple 2.35 40 0.00 > > > when i do: >> paste(sqlFetch(channel,'transactions')) > > outputs are: > [1] "c(1, 1, 2, 2)" > [2] "c(7, 8, 6, 1)" > [3] "c(1.8, 2, 1.99, 2.35) " > [4] "c(10, 5, 9, 40)" > [5] "c(0, 0, 0, 0) " > > > any idea why the orderid and the productname have been changed?? and what
The results of sqlFetch is a data frame whose alphanumeric columns are factors. You need to spend some (more) time with "An Introduction to R" learning about R's data structures and basic procedures BEFORE you start using it. After you have done so, ?do.call and ?factor will tell you how to deal with this sort of thing. But it is doubtful that you will understand until you have first spent some time with the basic docs. -- Bert > should i do to solve this?? > > Any help would be very appreciated! > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/value-changed-after-paste-function-tp3393845p3393845.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Bert Gunter Genentech Nonclinical Biostatistics 467-7374 http://devo.gene.com/groups/devo/depts/ncb/home.shtml ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.