Hello,
   I'm accessing a MySQL database from inside R and had a problem with a function. In the database, there is data from years 1985 to 2007 that I would like to retrieve. I can easily get the data from one year by the following:
info1985=dbGetQuery(con, statement='the SQL query')
Inside the statement, I have a column that is set to the desired year (e.g. table.column=1985) through a WHERE clause, but when I write a function like the following:
getinfo=function(t){dbGetQuery(con,statement='the SQL query')}
and instead of using a specific year, I substitute in t (e.g. table.column=t) in a WHERE clause
When I go to do
allinfo=sapply(c(1985:2007),getinfo)
I get the following error message: RS-DBI driver: (could not run statement: Unknown column 't' in 'where clause')
Is there anyway around this error? Or is not possible to substitute in years with a function and sapply through SQL?
Thanks so much.



      
	[[alternative HTML version deleted]]


