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
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.
______________________________________________
[email protected] 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.
