R help - Jan 2007 - RODBC

Hello, 

I am fairly new to R and its connectivity to MS-Access. I just installed
RODBC and it seems to be working well except when I use the date to
condition the query. For example the query below 

sqlQuery(channel, "select date from tblUScpi where (date > d2) order by
date")

returns the following error

[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "07001 -3010 [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1."

I checked that d2 and the elements in date belong to the same class
("POSIXt" "POSIXct"). Can anybody help me?
-- 
View this message in context:
http://www.nabble.com/RODBC-tf3084357.html#a8571820
Sent from the R help mailing list archive at Nabble.com.

On 1/24/2007 3:25 PM, jgaseff wrote:
> Hello, 
> 
> I am fairly new to R and its connectivity to MS-Access. I just installed
> RODBC and it seems to be working well except when I use the date to
> condition the query. For example the query below 
> 
> sqlQuery(channel, "select date from tblUScpi where (date > d2)
order by
> date")
> 
> returns the following error
> 
> [1] "[RODBC] ERROR: Could not SQLExecDirect"
> [2] "07001 -3010 [Microsoft][ODBC Microsoft Access Driver] Too few
> parameters. Expected 1."
> 
> I checked that d2 and the elements in date belong to the same class
> ("POSIXt" "POSIXct"). Can anybody help me?
If d2 is an R variable, you'll need to convert it to SQL syntax for 
dates (whatever that is, format() can probably do it).  R just passes 
the query string to the database, it doesn't do any variable 
substitutions for you.

Duncan Murdoch