variables inside an Rdi-select statement?!
Hello,
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
FROM ezg WHERE
ezg.s!='12'")
anyway, thank you for your help! cheers stephan
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