search for: 54469517def

Displaying 1 result from an estimated 1 matches for "54469517def".

2010 Oct 11
1
importing numeric types via sqlQuery
...692def 36428860.230769230769 I used the following R code to pull data into R:data <-sqlQuery(channel, "select category, num from temp;") However, the result is that "num" gets all its decimal places chopped off, so "data" looks like this instead in R:category numabc 54469517def 36428860 I've tried various alternative approaches, but none have fixed the problem. When I cast the variable to a numeric type like this (data <-sqlQuery(channel, "select category, num::numeric from temp;"), it still gave me the same result. Casting to a real type like this (data...