Re: [R] [RODBC] date attribute in sqlQuery

2008-08-12 Thread Prof Brian Ripley
On Tue, 12 Aug 2008, Abderrazzak MANY wrote: Hello R users, I would like to use an integer and a date as attributes in sqlQuery, and these arguments are defined in my function. Here is my function: GetReturn<-function(code,date) { channel<-odbcConnect("db","user1","password") ssql<-paste("

[R] [RODBC] date attribute in sqlQuery

2008-08-12 Thread Abderrazzak MANY
Hello R users, I would like to use an integer and a date as attributes in sqlQuery, and these arguments are defined in my function. Here is my function: GetReturn<-function(code,date) { channel<-odbcConnect("db","user1","password") ssql<-paste("select * from TABLE Where PF_CODE =",code,"and