This question doesn't appear to be related to Bioconductor packages.
You
will probably get better results by posting to R-help. In addition,
you
will probably need to tell people what package(s) you are using,
perhaps
by giving the results of sessionInfo().
Best,
Jim
Rudy van Eijsden wrote:
> Dear all,
>
>
>
> I use R to do SQLqueries in our Oracle database. When I do a query
to lookup
> positions of a clone in a 96-well plate, and the result should be
"F" for
> the row and "8" for the column, the SQLquery gives me "FALSE" and
"8" as a
> result.
>
> Why is "F" automatically displayed as "FALSE" and how do I correct
this?
>
>
>
> Many thanks in advance!
>
>
>
> Kind regards,
>
>
>
> Rudy van Eijsden.
>
>
>
> =================================================
> Rudy van Eijsden
>
> VIB MicroArray Facility
> <http: www.microarrays.be=""> http://www.microarrays.be
> <blocked::http: www.vib.be=""/> http://www.vib.be
> =================================================
>
>
>
>
> [[alternative HTML version deleted]]
>
> _______________________________________________
> Bioconductor mailing list
> Bioconductor at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/bioconductor
> Search the archives:
http://news.gmane.org/gmane.science.biology.informatics.conductor
--
James W. MacDonald, M.S.
Biostatistician
Affymetrix and cDNA Microarray Core
University of Michigan Cancer Center
1500 E. Medical Center Drive
7410 CCGC
Ann Arbor MI 48109
734-647-5623
On Wednesday 21 November 2007 14:35, Rudy van Eijsden wrote:
> Why is "F" automatically displayed as "FALSE" and how do I correct
this?
F is an abbreviation of FALSE, in R,e.g.:
> class(F)
[1] "logical"
> typeof(F)
[1] "logical"
(likewise, T is the same as TRUE) If you want to keep it a string (aka
character), just try adding quotes in Oracle (select '"' ||
some_column || '"' ), and/or use as.character(thing) on the R side.
Hope this
helps,
Philip
--
Philip Lijnzaad, PhD
Holstege Genomics Laboratory
Dept. of Biomedical Genetics
University Medical Center (UMC), Utrecht
Stratenum room 2.133 (on Mondays and Fridays not in after 14.45)
MSN chat (*NOT* email): philip_lijnzaad at hotmail.com
P.O. Box 85060, 3508 AB Utrecht
(Universiteitsweg 100, 3584 CG Utrecht)
The Netherlands
tel: +31 (0)30 253 8464
fax: +31 (0)30 253 8479
