[R] value changed after paste() function

kellysong song.qiao at student.dit.ie
Mon Mar 21 16:18:10 CET 2011


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.



More information about the R-help mailing list