Displaying 1 result from an estimated 1 matches for "info1985".
Did you mean:
info18
2009 Apr 03
1
Functions Accessing Databases
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 instea...