From ripley at stats.ox.ac.uk  Tue Nov  9 22:14:45 2004
From: ripley at stats.ox.ac.uk (ripley@stats.ox.ac.uk)
Date: Tue Nov  9 22:14:53 2004
Subject: [Rd] colnames argument in sqlFetch backwards? (PR#7355)
Message-ID: <20041109211445.13A01EB64@slim.kubism.ku.dk>

Do read the FAQ and stop abusing R-bugs in this way.
I did ask privately, but you have continued to ignore my request.

BDR

On Tue, 9 Nov 2004 bgunter@gene.com wrote:

> Full_Name: Bert Gunter
> Version: 2.0.0 patched
> OS: Win2000
> Submission from: (NULL) (192.12.78.250)
> 
> 
> The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to be
> reversed, at least for .xls files.
> 
> ## z is a connection to an xls workbook opened by odbcConnectExcel()
> 
> > dat<-sqlFetch(z,'SuccessRates',colnames=FALSE)
> > dat[1:5,]
>   RecID     Name Run  Grams Lost Run (80L)
> 1    NA Activase 117 839.91              0
> 2    NA Activase 118 860.52              0
> 3    NA Activase 119 921.23              0
> 4    NA Activase  NA     NA              1
> 5    NA Activase 120 722.62              0
> 
> > dat2<-sqlFetch(z,'SuccessRates',colnames=TRUE)
> > dat2[1:5,]
>   NA Activase 117 839.91 0
> 2 NA Activase 118 860.52 0
> 3 NA Activase 119 921.23 0
> 4 NA Activase  NA     NA 1
> 5 NA Activase 120 722.62 0
> 6 NA Activase 121 762.48 0
> 
> I note also that the last column, "Lost Run (80L)," was actually TRUE/FALSE and
> some blanks in the Excel sheet and was silently coerced to numeric. This is no
> problem, of course, but I wonder if it's the intended behavior and, if so, is it
> documented?
> 
> ______________________________________________
> R-devel@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
> 
> 

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595


[Rd] colnames argument in sqlFetch backwards? (PR#7355)
ripley@stats.ox.ac.uk