search for: lapsley

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael Lapsley's ODBC interface which seems now available for Unix, see www.ndirect.co.uk/~mlapsley as ROD...

...eing a real pain I'm mulling over a project that would have dynamically generated graphs displayed on a web page: mouse capture clearly is out! Would saving graphs in pnm or some other convertable format be difficult? (Or perhaps there is a package that I have not noticed?) Regards, Michael Lapsley ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 01-Oct-99 Time: 00:13:26 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read...

...This does not: > boxplot(c(1,2,3,4),c(1,2,3,4),xlab=expression( alpha * "-1-m")) Error: Object "alpha" not found > Tried it on both 0.63 and 0.64 with same result. Any help much appreciated: the scatterplots look so much better with the proper greek. Regards, Michael Lapsley ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 20-Apr-99 Time: 00:23:47 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read...

Here is a possible BUG with as.data.frame() and/or [.data.frame which broke Michael Lapsleys RODBC-Code. Can anyone confirm it is a bug or a 'feature' of the prototype? tablename <- "abc" a <- as.data.frame(cbind("abc", 1:3)) b <- as.data.frame(cbind(tablename, 1:3)) # ok > a V1 V2 1 abc 1 2 abc 2 3 abc 3 # missing column name > b tab...

...st(JMC = 4, LCA = 259, MCM = 136, MDH = 266, ML = 27, SA = 1), .Names = c("JMC", "LCA", "MCM", "MDH", "ML", "SA" ), row.names = "1", class = "data.frame") > ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 13-Oct-99 Time: 01:12:23 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send &quot...

...This is not exactly intuitive and it took me ages to get past what should be a very simple couple of lines. Am I missing something more obvious? I'm sure that if I need to do this in 6 months time I'm not going to remember how I did it! ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 12-Oct-99 Time: 00:04:03 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send &quot...

...to build? I am tarting up my odbc library, and I would like to stop the install process if the needed header files and libraries are not present on the system. Error messages flash past so fast that it is easy to miss their significance. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 06-Nov-99 Time: 19:16:30 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send &quot...

...x86 os Win32 system x86, Win32 status major 1 minor 0.0 year 2000 month February day 29 language R > -----Original Message----- > From: Prof Brian Ripley [mailto:ripley@stats.ox.ac.uk] > Sent: Wednesday, March 08, 2000 11:29 AM > To: dajm@deeq.demon.co.uk; mlapsley@ndirect.co.uk > Cc: jens.oehlschlaegel-akiyoshi@mdfactory.de > Subject: Re: [R] RODBC > > > > > Date: Wed, 8 Mar 2000 08:23:02 +0000 > > From: Michael Lapsley <mlapsley@ndirect.co.uk> > > To: David Middleton <dajm@deeq.demon.co.uk> > > Cc: Michael...

Dear, I am now writing more formal "academical" paper, and would like to reference an R package. Do you have any recommendation how to do it? Taking for instance the RODBC package as an example, how would the reference look like? http://cran.r-project.org/web/packages/RODBC/index.html Thank you Jan [[alternative HTML version deleted]]

...c(2,4,6,8),log="Y") Segmentation fault (core dumped) [ml at athome ml]$ Seems the bug is in errorcall(). yes, I know the syntax is wrong, but it is an easy mistake to make and it is inconvenient to lose the work space at times. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 18-Oct-99 Time: 00:39:06 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send &quot...

....seanet.com/~pburns/Spoetry/Spoetry.pdf Its about 439 pages with 16 chapters. You can read all about it at http://www.seanet.com/~pburns/Spoetry/ Michael Lapsley <mlapsley at ndirect.co To: r-Help List <r-help at stat.math.ethz.ch> .uk> cc: Michael HART <...

Firstly can I add my congradulations to the R core team on the release of v1.0.0 and my thanks for all their hard work. To the subject of this message: does anyone have a binary version of Michael Lapsley's RODBC package built for win32 that they can distribute? I have a solution where I can use Perl ODBC functions to dump data to a text file for reading in to R, but I think the direct ODBC call from R would be a cleaner way of working. Thanks David Middleton dajm at deeq.demon.co.uk -.-.-.-....

Dear all, platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status major 1 minor 2.3 year 2001 month 04 day 26 language R I wrote the following to import tables in different database formats (Access, Visual FoxPro, etc.): getTable <-

...1) I think that this package is *extremely* valuable : it fulfills a need quite important in the case of iterative (e. g. periodic) analyses. No need to periodically return to your data and re-dumping them ... 2) The current version has a serious bug if your datasets has missing numeric values. M. Lapsley, the original author, is aware of it, but has had no time yet to look at it ... I looked into the source to no avail. I'll have to dive in ODBC library mysteries (which are pure Swahili to me ...), and did not yet had time for this. <OffTheTopOfMyHeadIDontHaveTheFilesOnHand> In interim,...

...Windows against Access, MySQL and Excel. The CRAN compilation checks were against iODBC. I had to make quite a lot of internal changes, so would appreciate success/problem reports for other uses. There are several improvements in this version, some of which I had previously submitted to Michael Lapsley: see the ChangeLog. I am moving towards a 1.0 release which will be somewhat incompatible (`channel' will be a classed object and quoting names will be essential to allow them to be passed as R variables, for example). In the longer term the planned DBI/ODBC interface may replace RODBC entire...

...Windows against Access, MySQL and Excel. The CRAN compilation checks were against iODBC. I had to make quite a lot of internal changes, so would appreciate success/problem reports for other uses. There are several improvements in this version, some of which I had previously submitted to Michael Lapsley: see the ChangeLog. I am moving towards a 1.0 release which will be somewhat incompatible (`channel' will be a classed object and quoting names will be essential to allow them to be passed as R variables, for example). In the longer term the planned DBI/ODBC interface may replace RODBC entire...

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

On behalf of Michael Lapsley, who is away. There is a new version of RODBC on CRAN, version 0.8-2. A version compiled for rw1011 will propagate to CRAN tonight. Main differences: - This will work with the up-coming R 1.2.0. - Nulls in databases are handled (more) correctly. The bug that has been reported with repeate...

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

...cal Excel) and Linux (links to Postgres, both local and remote, ODBC manager=unixODBC, drivers=unixODBC-bundled drivers). A cursory preliminary look at the code was unsuccessful. I have to delve into the ODBC interface specification and learn how to debug C under R in order to go further. Michael Lapsley, author of the RODBC package, is aware of the problem, but has no fix yet (as of beginning of October). -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help&qu...