Message-ID: <20020802153516.042a5cd2.sholl@gmx.net>
Date: 2002-08-02T13:35:16Z
From: Stephan Holl
Subject: variables inside an Rdi-select statement?!
In-Reply-To: <Pine.LNX.4.31.0208021402370.31864-100000@gannet.stats>
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