R help - Apr 2003 - SQL and system

Hi All,
 
I’m using system commands in R to send requests to my database.
 
CMD=paste(“isql.tcl \’ select xxxx from yyyyy where zzzzz = 501 \’”)
Data=system(CMD,intern=T)
 
This works perfectly fine, but if I want to be able to add dates
constraints:
In command line it would be
isql.tcl “ select xxxx from yyyyy where zzzzz = 501 and date>’20021020’
”
 
 
Does somebody has an idea how to translate this into R code?
 
Thank you for your time,
Julien Dinh
 
 
 

	[[alternate HTML version deleted]]

Does the greater than sign in the isql.tcl command need to quoted
in some way to protect it from being interpreted by the shell ?
(That's just a guess.  I don't understand why there's an R question
here.)

-  tom blackwell  -  u michigan medical school  -  ann arbor  -

(all the quotes in Julien's message below seem to have been trashed
by switching from one encoding to another - sorry.)

On Tue, 1 Apr 2003, Julien Dinh wrote:
> Hi All,
>
> I’m using system commands in R to send requests to my database.
>
> CMD=paste(“isql.tcl \’ select xxxx from yyyyy where zzzzz = 501 \’”)
> Data=system(CMD,intern=T)
>
> This works perfectly fine, but if I want to be able to add dates
> constraints:
> In command line it would be
> isql.tcl “ select xxxx from yyyyy where zzzzz = 501 and date>’20021020’
”
>
> Does somebody has an idea how to translate this into R code?
>
> Thank you for your time,
> Julien Dinh