Re: [R] SQL Server "float" is not handled by RODBC -- Is there a workaround?

2015-10-15 Thread Mark Dalphin
more typical query if I can grab the whole thing at once rs <- dbGetQuery(conn, 'SELECT * FROM Orders;') print(rs) dbDisconnect(conn) Hope this helps; I might be able to help with specific examples for some of the DBI methods, if you need it. I suspect that what I have written abov

Re: [R] SQL Server "float" is not handled by RODBC -- Is there a workaround?

2015-10-15 Thread Mark Dalphin
say anything at all ... Also, it might be worth while posting on the DB specific maillist: https://stat.ethz.ch/mailman/listinfo/r-sig-db Hope this helps, Mark Dalphin On 15/10/15 07:23, jim holtman wrote: > Here is the system I am using: > = >>

Re: [R] [SOLVED] Problem building R-2.15.3 from source

2013-07-10 Thread Mark Dalphin
m good for the time being and hope this helps others who have trouble building from source. Cheers, Mark Mark Dalphin wrote: Hi, I have for many years build R from source for Linux. I have just run into my first problem with this in ... I don't know how long. uname -a Linux douglas

[R] Problem building R-2.15.3 from source

2013-07-10 Thread Mark Dalphin
raphics,stats" LC_ALL=C ../../../bin/R --vanilla --slave > /dev/null make[4]: *** [../../../library/stats4/R/stats4.rdb] Error 139 make[4]: Leaving directory `/home/mdalphin/src/R-2.15.3/src/library/stats4' make[3]: *** [all] Error 2 make[3]: Leaving directory `/home/mda

Re: [R] daylight

2012-10-23 Thread Mark Dalphin
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. -- Mark Dalphin Ph.D. Director of Bioinformatics mark.dalp...@pacific

Re: [R] What makes R different from other programming languages?

2012-08-20 Thread Mark Dalphin
I've read several replies to this question already and they seem to have missed the one point that most irritated the Java programmers to whom I tried to teach R. They HATED the "object-oriented" material, both S4 and especially S3, as it did not match the style of OO programming that had been poun

Re: [R] Not able to write to PostgreSQL database using "dbWriteTable"

2012-06-13 Thread Mark Dalphin
nt(conn, statement, ...) : RS-DBI driver: (could not Retrieve the result : ERROR: syntax error at or near "16" LINE 1: INSERT INTO test1 (id) VALUES ( 2012-06-10 16:36:00+05:30 ); ^ ) NULL *

Re: [R] Not able to write to PostgreSQL database using "dbWriteTable"

2012-06-12 Thread Mark Dalphin
e table. Try using (untested): dbGetQuery(connAE1, sprintf("INSERT INTO test1 (id) VALUES ( %d );", i)) and you will find things go better, assuming I grasped the problem you are having correctly. Regards, Mark Dalphin Prakash Thomas wrote: Dear R User's Please help me to debu

Re: [R] Way OT: Anyone know where to get data on relationship between education and salary

2011-04-18 Thread Mark Dalphin
ance doesn't show me "education" associated with these data, but I am not looking hard. Most of the rest of the information you want appears to be present. Regards, Mark Dalphin Paul wrote: I'm sorry for the way OT post, but here goes. I'm an informatics specialist, and

Re: [R] Problems drawing a colored 'rug' in the Lattice 'densityplot'

2010-12-15 Thread Mark Dalphin
tical Computing Facility Department of Statistics UC Berkeley spec...@stat.berkeley.edu On Thu, 16 Dec 2010, Mark Dalphin wrote: Hi All, I'm trying to add a 'rug' representation of my data to a plot created with densityplot

[R] Problems drawing a colored 'rug' in the Lattice 'densityplot'

2010-12-15 Thread Mark Dalphin
Hi All, I'm trying to add a 'rug' representation of my data to a plot created with densityplot(). While I can do this in the simple case, I can't do it properly when I include the "groups" argument. I have an example below. I am running a reasonably new version of R. print(sessionInfo()) R v

Re: [R] Source awareness?

2010-10-07 Thread Mark Dalphin
Well, Bill, at risk of embarrassing myself, in my case, I have gone this sort of route out of plain wrong thinking. I took way too many years to learn about R packages; it seemed that hurdle was too high (it wasn't really) and so I followed the kinds of tricks that I needed to do in other langu

[R] Problem using with panel.average in Lattice package

2009-10-02 Thread Mark Dalphin
using panel.loess in place of panel.average; it performs in a manner similar to what I want panel.average to do except it shows a loess line rather than a straight line connecting the means of the groups. Please see my coded examples, below. Regards, Mark Da