[R] variables inside an Rdi-select statement?!

Stephan Holl sholl at gmx.net
Fri Aug 2 15:35:16 CEST 2002

> Use paste() to assemble the string you want to pass.  Nothing you did
> tells R that `ezg' in the last line is a reference to an R variable. 
> I'd give you an example except I don't see the point of your SQL.  I
> think you may mean
> paste("SELECT s FROM", ezg, "WHERE s!='12'")

yes, indeed, that's what I ment. But I shortend my real SQL statement
for the mail-example. I did some left joins and in order to have an
atomic id-field I had to write the relation like this ("SELECT ezg.s
> ezg.s!='12'")
anyway,  thank you for your help!


Linux: the operating system with a CLUE...
         Command Line User Environment.
Stephan Holl
GnuPG Key-ID: 11946A09
ICQ# 117277975 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : https://stat.ethz.ch/pipermail/r-help/attachments/20020802/9d16a39e/attachment.bin

More information about the R-help mailing list