Displaying 1 result from an estimated 1 matches for "pf_date".
Did you mean:
df_date
2008 Aug 12
1
[RODBC] date attribute in sqlQuery
...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 PF_DATE=",date)
mydata<-sqlQuery(channel,ssql)
mydata
}
Actually, the channel is open but the query on the table did not work.
The command paste worked for the integer argument but not for the date.
Thank you for helping.
A.Many